Ask Lemmy
A Fediverse community for open-ended, thought provoking questions
Rules: (interactive)
1) Be nice and; have fun
Doxxing, trolling, sealioning, racism, toxicity and dog-whistling are not welcomed in AskLemmy. Remember what your mother said: if you can't say something nice, don't say anything at all. In addition, the site-wide Lemmy.world terms of service also apply here. Please familiarize yourself with them
2) All posts must end with a '?'
This is sort of like Jeopardy. Please phrase all post titles in the form of a proper question ending with ?
3) No spam
Please do not flood the community with nonsense. Actual suspected spammers will be banned on site. No astroturfing.
4) NSFW is okay, within reason
Just remember to tag posts with either a content warning or a [NSFW] tag. Overtly sexual posts are not allowed, please direct them to either !asklemmyafterdark@lemmy.world or !asklemmynsfw@lemmynsfw.com.
NSFW comments should be restricted to posts tagged [NSFW].
5) This is not a support community.
It is not a place for 'how do I?', type questions.
If you have any questions regarding the site itself or would like to report a community, please direct them to Lemmy.world Support or email info@lemmy.world. For other questions check our partnered communities list, or use the search function.
6) No US Politics.
Please don't post about current US Politics. If you need to do this, try !politicaldiscussion@lemmy.world or !askusa@discuss.online
Reminder: The terms of service apply here too.
Partnered Communities:
Logo design credit goes to: tubbadu
view the rest of the comments
I only use SQL at work and not really had much use with AI. I can't give it our databases and the time it takes to describe the issue is usually slower than writing the solution myself.
I have had it provide useful output when other options failed but it's few and far between.
I have some experience with SQL from Access. I can see it providing some guidance for how to do a join, but the deeper you get the more it starts resembling an expanded regex. I don't expect the generated SQL to get the lists and parenthesis correct.
Why would I need an LLM to join 2 tables?
Not as much as asking the LLM to do so, but I feel that joining two tables is a basic task for us but I wouldn't entrust it to the machine.
Asking an LLM takes longer than typing join myself and is more likely to get it wrong.
I get it. You know what you have to do and it's faster if you do it yourself. It was the point I was getting at.