Return the SQL only, do not include explanations.” The following function creates a query in that type of format, taking arguments for the data schema, sample rows, user query, and table name.

An alternative - again, if supported - would be to create a view that works the same as the derived table, and use this in your query instead.

Microsoft Copilot can write basic SQL code for your employees. Read about our tests that prove this is true.

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data.

Examples include Microsoft Copilot for Power BI and Databricks LakehouseIQ. These assistants expose an NLQ prompt to automate the creation of a chart or dashboard or to write SQL.