Clojurians Log v2
honeysql
https://honeysql.fly.dev/ prototype SQL to HoneySQL translator
I typed in select a from x and got nothing -- is there some button or action to trigger the translator?
oh sorry, i always do ctrl-enter
was going to add a button and just forgot
It looks a bit LLM-ish -- is that how it works behind the scenes? Ask for HoneySQL expression to generate the given SQL, then run it through format to see if it produces the right output?
yes, it is a fine-tuned gpt-3.5
hopefully more training data will help with those cases
it doesn't do insert into x select yet either
Interesting approach...
So far I'm seeing it get SELECT a AS b and INSERT INTO a SELECT ... wrong. Postgres operators like -> too
I plan to cut a new HoneySQL release before the end of the month with https://github.com/seancorfield/honeysql/issues/510 and https://github.com/seancorfield/honeysql/issues/511 both addressed. A first cut of both is available on the latest develop branch and as the latest 2.4.9999-SNAPSHOT if folks would like to test the new features and a) make sure they work and b) provide feedback. The NRQL dialect is very much a "first cut". It doesn't support all of the NRQL extensions to SQL: I want to see what sort of stuff people want/need before I spend effort on extensions that "no one uses" 🙂
I think the initial NRQL support is sufficient for my needs. I’ll double check tomorrow.
@markaddleman How's the improved BigQuery support working for you?
Works great. I have a very simple use case and I’m not sure how complicated it gets but the implementation looks good to go
Thank you, both. I'll probably cut the release mid-week.
I double checked, and it's good for me for now. Thank you Sean!