DataGrip 2020.2 EAP 3

Posted on by Maksim Sobolevskiy

Hello,

Here is a new build as part of our DataGrip 2020.2 Early Access Program.

Google BigQuery dialect

We’ve added a new SQL dialect: Google BigQuery. Full support for BigQuery is not here yet, but all things must begin somewhere. So far, DataGrip can correctly highlight and provide coding assistance for your queries if you use Google BigQuery.

TextMate bundles

TextMate, a text editor for Mac, offers syntax highlighting bundles for many languages. We can import and use them in DataGrip. Starting with this release, the IDE will provide syntax highlighting for the file types registered with the bundle.

Now your Python, JavaScript, Shell, and many other types of files will have syntax highlighting by default. To see all the applicable file types, go to Settings/Preferences | Editor | TextMate bundles.

SQL 2016 for Generic dialect

Now files and consoles that are highlighted with the Generic dialect are highlighted with SQL 2016. Previously, SQL 92 was used. The main improvement from this change is the ability to run common table expressions without selecting.

Other improvements and fixes

DBE-11059 [Exasol]: We’ve added support for the new syntax in analytic functions.

DBE-11056 [Oracle]: We’ve added support for inline external tables in SELECT statements.

DBE-10919 [MySQL]: The aliases defined in outer queries are highlighted correctly.