Postgres, MySQL, MS-SQL, SQLite and Oracle all implement the ANSI-92 standards but also have proprietary extensions as you have discovered. If you want your database code to be portable between platforms you need to stick to the ANSI standards but I have never seen it in real life. The cost of delevoping portable database code is probably more expensive than refactoring when a migration is required and you will lose out on platform specific optimisations
I've been coding for over 20 years now! (WOAH, do I feel old)
I've touched just about every resource imaginable under the Sun (too bad they were bought out by Oracle)
The other option is to abstract away the SQL queries with a generator that is acutely aware of subtleties in different database systems. That's one of the main goals of PUDL! :) github.com/darkain/pudl
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Postgres, MySQL, MS-SQL, SQLite and Oracle all implement the ANSI-92 standards but also have proprietary extensions as you have discovered. If you want your database code to be portable between platforms you need to stick to the ANSI standards but I have never seen it in real life. The cost of delevoping portable database code is probably more expensive than refactoring when a migration is required and you will lose out on platform specific optimisations
The other option is to abstract away the SQL queries with a generator that is acutely aware of subtleties in different database systems. That's one of the main goals of PUDL! :) github.com/darkain/pudl