-- 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:
-- Rank products by sales per category Copilot writes the RANK() OVER (PARTITION BY category ORDER BY sales DESC) correctly, saving you from syntax searches. Highlight a 20-line nested subquery. Press Ctrl + Enter (or Cmd + Enter on Mac) and ask: 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