I Built a SQL Query Builder in Python - Never Hand-Write SQL Again

I Built a SQL Query Builder in Python - Never Hand-Write SQL Again I was debugging a production database issue last month. A colleague's query: SELECT users . id , users . name , users . email , orders . id , orders . total , products . name , products . price FROM users LEFT JOIN orders ON users . id = orders . user_id LEFT JOIN order_items ON orders . id = order_items . order_id LEFT JOIN products ON order_items . product_id = products . id WHERE users . created_at > '2024-01-01' AND orders . status = 'completed' ORDER BY orders . total DESC LIMIT 100 Query was slow. But hard to read. I thought: Why are we hand-writing SQL like it's 1995? So I built SQL Query Builder CLI — a tool that generates complex SQL queries from simple specifications. Now I write queries in 30 seconds instead of 5 minutes. The Problem: SQL is Annoying to Write Hand-writing SQL is painful because: Syntax errors — Missing commas, mismatched parentheses, typos Hard to read — Complex joins span 20 lines Time-consu