News for hackers. Stuff that matters.
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by delichon on Monday February 05, 2024 @10:26AM (#39262186)
So you feed it the whole DDL with the prompt. I wonder how it performs on a task like schema normalization or optimization? Say, also include the slow queries log and ask it for the SQL commands to modify the indexes to speed up those queries. Allow it to normalize/denormalize/materialize as options. Give it a way to run the resulting DDL against a test suite and iterate toward some fitness goal.

This would save gobs of compute.

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by thecalebf on Monday February 05, 2024 @10:49AM (#39262389)
That is really interesting. I took note of this. That would be really cool!