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

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.

New open-source efforts from Snowflake aim to help solve that unsolved challenges of text-to-SQL and inference performance for enterprise AI.