SQL Query Builder

The builder pattern constructs a complex object step by step and produces the final result at the end, so callers can set the parts in any order.

Each part is a keyword, a space, and its text:

• select <columns>: comma-separated column names (spaces around commas may vary). Optional; the default is *.
• from <table>: required.
• where <condition>, order <columns>, limit <n>: optional.

If a keyword appears more than once, the last one wins. Build the query in this fixed order, with single spaces:

SELECT <columns> FROM <table>[ WHERE <condition>][ ORDER BY <columns>][ LIMIT <n>]

In the SELECT list, trim each column and join them with , . All other texts are copied unchanged.

Implement query_builder(parts).

Input

parts: The parts, in any order.

Output

Return the SQL query string.

เงื่อนไข

1 ≤ number of parts ≤ 20

At least one from part; each part has at most 100 characters

ตัวอย่าง

อินพุต:
parts = ["where age \u003e 18", "from users", "select name,age"]

ผลลัพธ์ที่คาดหวัง:
expected = "SELECT name, age FROM users WHERE age \u003e 18"

อินพุต:
std::vector<std::string> parts = {"where age \u003e 18", "from users", "select name,age"};

ผลลัพธ์ที่คาดหวัง:
std::string expected = "SELECT name, age FROM users WHERE age \u003e 18";

อินพุต:
string[] parts = new string[] {"where age \u003e 18", "from users", "select name,age"};

ผลลัพธ์ที่คาดหวัง:
string expected = "SELECT name, age FROM users WHERE age \u003e 18";

อินพุต:
parts = ["from orders", "limit 10", "order total DESC"]

ผลลัพธ์ที่คาดหวัง:
expected = "SELECT * FROM orders ORDER BY total DESC LIMIT 10"

อินพุต:
std::vector<std::string> parts = {"from orders", "limit 10", "order total DESC"};

ผลลัพธ์ที่คาดหวัง:
std::string expected = "SELECT * FROM orders ORDER BY total DESC LIMIT 10";

อินพุต:
string[] parts = new string[] {"from orders", "limit 10", "order total DESC"};

ผลลัพธ์ที่คาดหวัง:
string expected = "SELECT * FROM orders ORDER BY total DESC LIMIT 10";

แหล่งอ้างอิง

โจทย์นี้ปรับให้เหมาะกับ CodeUtility กรุณาทำตามคำชี้แจงและข้อจำกัดด้านบน

• Refactoring.Guru, Design Patterns
• Gamma, Helm, Johnson, Vlissides, Design Patterns: Elements of Reusable Object-Oriented Software