Blog Post

Azure SQL Blog
3 MIN READ

GitHub Copilot for SQL Developers: Turbocharge your SQL Development Workflow

subhojitbasak's avatar
subhojitbasak
Icon for Microsoft rankMicrosoft
Jul 18, 2023
Blog 1 Congratulations on starting your journey as a database developer in a new organization! As you embark on this exciting chapter of your career, you'll encounter various challenges and opportu...
Updated Sep 01, 2023
Version 2.0
azure sql
sql server
COBOL_84's avatar
COBOL_84
Copper Contributor
Jan 03, 2024

It appears that copilot is acting like a 4GL (4th generation language). And like all 4GLs the instructions are more related to human language but complex instructions are difficult to convey. Think of trying to conveying in English a recursive query involving a dozen or more joins, unions, and subsets (and make that query efficient). What would really be beneficial is a self tuning database, one that would optimize performance based on past queries.