▲ | sgarland a day ago | |
It's not a strawman, it's reductio ad absurdum. SQL and Python are both languages that are commonly used. It would be (currently; who knows in a few years) laughable if someone said they didn't need to deeply understand Python to be able to correctly write Python at an employable level, modulo experience levels - I don't expect a Junior to know the vagaries of the language, e.g. that bools are aliased to integers. > Even developers know little SQL unless it's their specific focus. Yes, and I believe this to be deeply problematic. We don't generally allow people to use a language they don't understand in production, except for SQL. > Where I live, every college level developer went through multiple semesters of database courses and yet I don't see these people proficient in SQL. That's horrifying. Look, while I would love it if everyone writing SQL knew relational algebra, basic set theory, and the ins and outs of their specific RDBMS implementation, I think the below suffices for the majority of work in web dev:
You're telling me that given a simple educational schema like Northwind Traders, and the documentation for their RDBMS, that someone who already knows a programming language couldn't use the above to figure it out in a fairly short order? | ||
▲ | brulard a day ago | parent [-] | |
You made here an important assumption > someone who already knows a programming language I'm sure someone who can already code, can write a simple query. But my argument is 1. with AI assistance programmer would be quicker, with less friction, more productive, enabled to make queries beyond his current abilities 2. with AI assistance Non-programmer would be enabled to use SQL at all 3. real world queries are often not trivial (todays developers have simple queries covered by ORM / query building tools) Regarding real life queries - I look at my last query that I crafted with difficulty and AI help - starts `WITH RECURSIVE`, uses `UNION ALL`, `GROUP_CONCAT`, `COALESCE` (even with SELECT statement inside), multiple CTEs. It would take me hours to get to that. I can have that in minutes with AI help. I don't even mention different dialects, feature support, arrays and JSONs, extensions, etc. |