How to add a SQL Dialect?

Hello

Is there some How-to, tutorial or similar about adding SQL dialects?

I have a SQL like dialect we are using in my company extensively and I would like users have all the support (possible) from datagrip on that dialect.

Regards,

Pablo

30
21 comments

Yeah, it would be great to be able to do this. I've started using Datagrip with Hive and Presto, using their JDBC drivers, and while most things work, the syntax highlighting and error detection get very confused. The reality is that these dialects aren't that different from most other SQL-like dialects, feels like it should be easy to just have a config file somewhere where you could add the reserved words and synonyms for the sql standards or something.

6

Same here, Presto and Hive are missing for us.

6
Avatar
Michael Andreacchio

+1 Please implement this feature

3

Please implement a way to do this

2

In my case, we have a SQL dialect that is not public (at least right now), so we need an (easy) way datagrip supports him by using condiguration/parser file/s.

2

+1

0
Avatar
Permanently deleted user

+1

0
Avatar
Permanently deleted user

This will be nice to add support for Hive.

0

+1

0

Hi,

As mentioned earlier, please vote for https://youtrack.jetbrains.com/issue/DBE-3142

Thank you.

1

+1

0

+1 :)

0

+1 also need presto badly for AWS Athena!

2

+1 for AWS Athena

0

The best way to vote for desired dialect is in our public bug-tracker, e.g. for AWS Athena https://youtrack.jetbrains.com/issue/DBE-6089

0

+1, im need creating SQL dialect for Intersystems IRIS Database. (rmedina, Chile)

1

Please sign in to leave a comment.