i just had an experience where i had to write some code, and i really couldn't be bothered to understand the problem and the tools at my disposal, and then i went onto ChatGPT & asked and it gave me a sensible answer and i didn't have to think. incredible! i am normally a LLM hater when it comes to coding, based on trying out Copilot for a bit when it was first announced.
-- sidebar for the actual problem! --
the problem was "can you write a query that will get all of the user_ids from the featured_users table, except the ones that are being blocked by a particular user?", it gave me
SELECT fu.user_id
FROM featured_users fu
LEFT JOIN blocks b ON fu.user_id = b.blocked_user AND b.blocking_user = 'specific_user_id'
WHERE b.blocking_user IS NULL;
i am slowly building up my knowledge of SQL with this project, but... fits and starts. in this case the bit i was missing was applying conditions to the ON of a LEFT JOIN that aren't actually related to the join itself. and, tbh, just confidence in which join is which.
-- sidebar ends --
so, okay, now updated my mental model to say that LLMs are sometimes good for code. but only code when you think "ugh, i know this is straightforward, i just can't be bothered to learn it myself"