How do you practicale use it or see practical usage for other users?
Surely I have a lot of SQL, and sometimes I need SQL generated.
Now how do you practically use it?
Do you enhance the SQL queries for performance?
Generating new queries makes sense, and I will soon try it out.
Creating triggers and conditions is useful to me.
The targeted task of this model is generating new queries starting with SELECT.
I didn't know about the last requirement. If popular, then a separate model needs to be fine tuned.
LLM developments are driven by benchmarks. Sadly if a prominent benchmark doesn't exist for a pocket of user requests, they will be ignored 😔
SELECT feature only is IMHO very limited. I have 278 tables in the database, many of them need constraints, triggers. And I have complex SELECTs from 3 tables and similar. I did not test the model for that. We will see later.
Wow! the context window should be able to hold these many tables, but they are way beyond what the training and eval sets have assumed. Let's see how the model generalizes to this 😅
For sure I would not enter all tables in it. Rather one by one, depending which one needs the improvement. I have in particular important table transactions where affected financial accounts must belong to the same referenced elementary object, I will tell you how it works.
You said users should get 32B version, so that is what I am going to download, and will tell you the result.
Of course. How often will you use LLM for this? You could learn the query from LLM and keep reusing it, or keep coming back to LLM
I know queries, but why waste time typing when I can just speak, get SQL and copy into the psql? :-)
I'm adding triggers and I was updating and it worked well these last days. I had actually no problem at all. I did not have a single error. Though I must say that the Microsoft Phi-4 also works very good. Using 7B model it is better for the low-end devices where it can fit into the RAM. I'm still using this one whenever need some kind of SQL special statement.
I will keep reporting here for a few times over the next days depending how much I'm updating the database.