I'm testing your promising DataGrip IDE. Most of things are really brilliant. There is one thing I'm missing: Starting with MariaDB 10.2 there is the WITH statement known as CTE (common table expression) that other databases are having for a long time but not MySQL.
DataGrip didn't recognizes this statement.
WITH test AS (
SELECT * FROM test;
Table 'db.test' doesn't exist
If I'm switching the dialect from MySQL to Oracle or SQLite it is working fine. Is it possible to add a MariaDB 10.2+ profile to support these things? There are other need things in 10.2. like windowing functions that (maybe?) need some fine tuning on the MySQL dialect?