Github Copilot Datagrip -

-- Get all customers who placed orders in the last 30 days with total > $500 Copilot suggests the full SELECT ... JOIN ... WHERE ... GROUP BY instantly. It reads your schema context (if you’ve connected a database) and proposes column names from your actual tables. Forgot the syntax for ROW_NUMBER() partition? Type the goal:

-- daily sales report for last week: -- date, total orders, total revenue, average order value Copilot generated: github copilot datagrip

Rewrite this using CTEs with clear names Copilot reformats it into readable WITH clauses. Writing insert scripts for a dozen columns? Start with: -- Get all customers who placed orders in