Version 2.9.8 finally fixes world's issues with SQL! 22 typical scalar functions now work portably across SQLite, MySQL, PostgreSQL. No other general purpose software I know does this.
Here's the list and it will be growing:
To understand how the compatibility is achieved see this openly available document.
The new Kexi speaks your language too. It checks correctness of your SQL:
If you type error in your statement Kexi carefully explains what's wrong:
Great tool no matter if you're power users crunching data or a student willing to learn some SQL technology.
In addition, this year the technology will be available as a KDE framework called KDb to everyone.
PS2: MSSQL support for the functions was also analyzed, just currently it's out of scope.