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
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.