Skip to content

Instantly share code, notes, and snippets.

@massimopiccardo
massimopiccardo / #Effortless SQL Query Crafting: Unleashing GitHub Copilot's.txt
Last active June 11, 2025 00:26
These are the files used in "Effortless SQL Query Crafting: Unleashing GitHub Copilot's Power" Medium post
These are the files used in Effortless SQL Query Crafting: Unleashing GitHub Copilot's Power post. See here:
https://medium.com/@massimopiccardo/effortless-sql-query-crafting-unleashing-github-copilots-power-d09136e92de8
DatabaseContextCreation_base.sql --> A basic query to generate a list of comments to use as a context for copilot generated queries
DatabaseContextCreation_relations.sql --> An evolution of the base one, adding foreing keys information
DatabaseContextCreation_descriptions.sql --> Another evolution, adding table and column free text descriptions
sp_AddUpdateDescription.sql --> A stored procedure to simplify the definition of descriptions ofr tables and columns