SQL Reserved Words – The Empirical List

Re:SQL Reserved Words – The Empirical List by EForEndeavour on Wednesday October 11, 2023 @11:39AM (#37845902)

This might reveal my technical mediocrity, but my approach:

1. Write the SQL that I think should mostly work

2. Try to run it

3. Fix errors with the help of docs, Stack Overflow, and now generative AI

4. Subconsciously learn whatever dialect this is to improve my performance on Step 1

[ Parent | on HN ]

Re:SQL Reserved Words – The Empirical List by gvx on Wednesday October 11, 2023 @12:11PM (#37846347)

This might work in the short term, but I don't recommend it as a general technique.

This sort of an approach often causes there to be hidden bugs, which do not generate errors now, but will cause some problem down the line.

It also has a tendency to lead to cargo cult programming (https://en.wikipedia.org/wiki/Cargo_cult_programming), which is less immediately problematic, but is still not great, especially for whoever needs to maintain that code.

[ Parent | on HN ]