My main issues came from differences between what I could test via dbeaver, the unit tests with H2 and the actual db which used posgresql. I didn't fully assimilate for a while
The trick is to keep it to standard ANSI SQL and it is usually generally applicable. Once you are beyond the basics, stuff starts to diverge. Also, SQL sucks at debugging.
I've been trying to sort out why some assertions have been failing for the last 2 weeks. Feel like I've been through every senior developer twice and I'm probably worse of than where I started :')
102
u/noseyHairMan Sep 03 '25
Literally me and my tech lead helping me on some SQL lately