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

21 comments
Comment actions Permalink

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
Comment actions Permalink

Same here, Presto and Hive are missing for us.

6
Comment actions Permalink

+1 Please implement this feature

3
Comment actions Permalink

Please implement a way to do this

2
Comment actions Permalink

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
Comment actions Permalink

This will be nice to add support for Hive.

0
Comment actions Permalink

Hi,

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

Thank you.

1
Comment actions Permalink

+1 also need presto badly for AWS Athena!

2
Comment actions Permalink

+1 for AWS Athena

0
Comment actions Permalink

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
Comment actions Permalink

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

1
Comment actions Permalink

Rimedinaz,

Could you file an issue in our bug tracker https://youtrack.jetbrains.com/issues/DBE ?

 

0

Please sign in to leave a comment.