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 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: github copilot datagrip
-- 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: Rewrite this using CTEs with clear names Copilot
INSERT INTO users (name, email, role, created_at, updated_at) Copilot suggests the rest of the columns and even generates sample test data. Staring at a 10-year-old stored procedure? Highlight it and use Ctrl + Enter : It reads your schema context (if you’ve connected