Working with code<\/h3>\n\n\n\n\n- DBE-4469<\/a>: We fixed the problem where SQL Formatter<\/em> didn\u2019t apply the right style for a subquery in the EXISTS clause.<\/li>\n<\/ul>\n\n\n\n
Now it works as expected, and DataGrip can also add a space between the EXISTS keyword and the left parenthesis. For this part, we also added a new setting. Now, if you want to preserve the old Formatter behavior (without the space), you can change the Space after keyword <\/em>setting to No<\/em> in Preferences | Editor | Code Style | SQL (<\/em>go to the Queries <\/em>tab).<\/em><\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2023\/02\/image-45.png\")
<\/figure>\n\n\n\n\n- DBE-14440<\/a> [H2]: We fixed the bug with saving style settings. If you have configured a special style for SQL2016 and the Inherit general SQL style<\/em> checkbox in Preferences<\/em> is not enabled, then you will need to reconfigure it.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2025\/09\/mB8fiekg6_fMsIgWaJVUX7XUXo_G3c8P5r1YGSrrAmV3L1IZm772ow4uF2ReZm9x1M1CARpbh_ydk6v9_zxDNh-K8pxERvFbYNP8lGHs54m7GyqMwnAaRLg5vGg3WOYeF-IJQtYgKF4EGUkxZvOhhhs.png\")
<\/figure>\n\n\n\nThe other fixes in this area are more or less self-explanatory:<\/p>\n\n\n\n
\n- DBE-15973<\/a> [BigQuery]: The WINDOW clause is now supported.<\/li>\n\n\n\n
- DBE-9219 <\/a>[Clickhouse]: \u0421ase settings when completing exact-case names are now ignored.<\/li>\n\n\n\n
- DBE-14796<\/a> [MySQL]: Problems with LAG and LEAD functions have been fixed.<\/li>\n\n\n\n
- DBE-16311<\/a> [MySQL]: FOR UPDATE in nested queries is now supported.<\/li>\n\n\n\n
- DBE-12139<\/a> [MySQL]: The ENCRYPTION syntax is now supported.<\/li>\n\n\n\n
- DBE-13186<\/a> [Microsoft SQL Server]: Inspections no longer erroneously report extra code.<\/li>\n\n\n\n
- DBE-11946<\/a> [PostgreSQL]: An issue with Place constraints<\/em> was fixed.<\/li>\n\n\n\n
- DBE-6276<\/a> [PostgreSQL]: DDL navigation to security policies now works as expected.<\/li>\n<\/ul>\n\n\n\n
Database explorer<\/h3>\n\n\n\n\n- DBE-17263<\/a>: Data source content statistics is again displayed in the Quick Documentation<\/em> popup.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2025\/09\/RHyIX8UdB__WSbn1_Y-yeAdaY7Vyf4Oaeui9LjBF0ZxYXEyN5kODbw2tqxrJlZ9N5HdN2BcCf79uiUDOLJ6WBhwDMJNIKLlsvkZBDMsFXQKv9DjOV0hd94OzzW3j0LzSV_CoVgZ2drR_js9G2rH0oWA.png\")
<\/figure>\n\n\n\n\n- DBE-10812<\/a> [PostgreSQL]: The Drop<\/em> context menu command now works as expected.<\/li>\n<\/ul>\n\n\n\n
Introspection<\/h3>\n\n\n\n\n- DBE-12578<\/a> [Oracle]: Cross database triggers are now supported. You can create a trigger X in schema A to table E in schema B, and it will be shown in schema B under the host table E.<\/li>\n\n\n\n
- DBE-6986<\/a> [MySQL]: The ROW_FORMAT clause\/syntax is now supported.<\/li>\n\n\n\n
- DBE-10603<\/a> [Microsoft SQL Server]: The Quick Definition<\/em> now works as expected.<\/li>\n\n\n\n
- DBE-9087<\/a> [PostgreSQL]: When using the clause REFERENCING, the trigger\u2019s DDL is generated correctly.<\/li>\n\n\n\n
- DBE-12404<\/a> [IBM Db2]: We fixed an issue with interrupting object introspection. If the user permissions did not allow retrieving a list of database users, the rest of the database objects were not loaded either. Now everything but the list of users will be loaded.<\/li>\n<\/ul>\n\n\n\n
Connectivity<\/h3>\n\n\n\n\n- DBE-16417<\/a> [Microsoft SQL Server]: Current schema<\/em> detection now works for any database.<\/li>\n\n\n\n
- DBE-11012<\/a> [SQLite]: The SQLite native library is now unpacked to the system folder.<\/li>\n<\/ul>\n\n\n\n
Object editor<\/h3>\n\n\n\n\n- DBE-16393<\/a>: We\u2019ve added a source editor to the Modify view.<\/em><\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2025\/09\/2LkfU_Rqsb5FMn0FYMsyu7yt8kI3fsY7v3OoI0GMsEebMqN1sg4fb5pLf4D4L9OIdmOwPWvTbRsS7NkVuAGvFVsW2FXf1CniZRpMFfgwaFoXOWthb49WApuUt4Wi40i-lkZAmMikp72v3nA5-s0_zZM.png\")
<\/figure>\n\n\n\n\n- DBE-17329<\/a> [PostgreSQL]: Virtual view creation is now also available in read-only mode.<\/li>\n<\/ul>\n\n\n\n
Data editor\/viewer<\/h3>\n\n\n\n\n- DBE-3572<\/a>: We\u2019ve added an Alternate row colors<\/em> setting for results tables. When the checkbox is enabled, rows will have alternating colors.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2025\/09\/orojVBrFm7Zfj9g6peHjJx_V3DYbSq90Hlo4uFqzRwP2mwcTV_T-LoEUsg0lECeaaZk7hc2jWUFmiY3XvCvU7STRvMTp17sshWnQ0PSnkKc97U-uXOaPd6PvvjVaKA6xVNAiOUOIhQoe_yVjCI640lY.png\")
<\/figure>\n\n\n\n\n- DBE-16250<\/a>: There are no more empty spaces in in-editor results, as the table now adjusts its height to match the height of the results.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2025\/09\/qy3RAhrQSZZD9hz0ut3pjWDuOklMJw9crNwDvs0P-_OqxE3Fi1RhTvGUvB5JjcgwfGtiSWkeV6-ZYPMKGpIz-hJcfatN-Rx18Mp-RHow89Sk5BiQ7udJHuvMkRKu561oFlQrigr7ORorq8hLjvL563g.png\")
<\/figure>\n\n\n\nQuery console<\/h3>\n\n\n\n\n- DBE-14074<\/a>: Named parameters are detected correctly.<\/li>\n\n\n\n
- DBE-10555<\/a>: Whenever you copy and paste something, the IDE now correctly analyzes the selection (instead of the cursor position).<\/li>\n\n\n\n
- DBE-12109<\/a> [Oracle]: Semicolons are no longer omitted in Oracle Aggregate Functions.<\/li>\n\n\n\n
- DBE-16871<\/a> [BigQuery]: The Unexpected value<\/em> error no longer pops up when previewing a table.<\/li>\n<\/ul>\n\n\n\n
SQL Resolve<\/h3>\n\n\n\n
DBE-16831<\/a>: A setting to specify the default resolve mode used in the console has been added to Preferences | Database | Query execution | Other.<\/em> <\/p>\n\n\n\n![](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2025\/09\/PTRBT1nFgrHqokvAFYFISzSJZxQ4y4zVyp5Rt-qWlyhVyOmiJBskSmMtE0NWpj0IMyQvaPgKZBybIFZhrzseTHI0g5ms6R_DpCsz9hgpoiqYYegZGQn-sDWM6kjNaRzH_me0bGA4ek0_3R_OJtUitIg.png\")
<\/p>\n\n\n\n
\n- DBE-5497<\/a> [Oracle]: We fixed a few problems with Oracle collection methods:
– Public synonyms are now correctly placed in the PUBLIC schema.
– Recursive references to nested routines are resolved correctly.
– Cursor parameter references qualified by a cursor name are resolved correctly.
– Incorrect usages of %TYPE are reported as warnings.<\/li>\n\n\n\n- DBE-12772<\/a> [Oracle]: We fixed the resolution of standard attributes for collection types (for example, COUNT).<\/li>\n<\/ul>\n\n\n\n
Explain plan<\/h3>\n\n\n\n\n- DBE-17137<\/a>: We fixed a bug where the IDE would show the Explain Plan diagram only for the first of several queries.<\/li>\n<\/ul>\n\n\n\n
Navigation and search<\/h3>\n\n\n\n\n- DBE-12015<\/a> [Oracle]: Go to Declaration (Ctrl\/Cmd+B or Ctrl\/Cmd+click) now navigates you to the routine implementation.<\/li>\n<\/ul>\n\n\n\n
<\/p>\n\n\n\n
<\/p>\n\n\n\n
\n\n\n\nThat’s it for now! Get the EAP 1 build<\/a> and try working in DataGrip without these nagging issues. And let us know what you think in the comments below! <\/p>\n\n\n\n\n- Report new bugs to our issue tracker<\/a><\/li>\n\n\n\n
- Tweet us!<\/a><\/li>\n\n\n\n
- Email us at datagrip@jetbrains.com<\/li>\n\n\n\n
- Contact our support<\/a><\/li>\n<\/ul>\n\n\n\n
<\/p>\n","protected":false},"author":1294,"featured_media":323179,"comment_status":"closed","ping_status":"closed","template":"","categories":[826,89],"tags":[],"cross-post-tag":[],"acf":[],"_links":{"self":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip\/323123"}],"collection":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip"}],"about":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/types\/datagrip"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/users\/1294"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/comments?post=323123"}],"version-history":[{"count":10,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip\/323123\/revisions"}],"predecessor-version":[{"id":627236,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip\/323123\/revisions\/627236"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/media\/323179"}],"wp:attachment":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/media?parent=323123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/categories?post=323123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/tags?post=323123"},{"taxonomy":"cross-post-tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/cross-post-tag?post=323123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Now it works as expected, and DataGrip can also add a space between the EXISTS keyword and the left parenthesis. For this part, we also added a new setting. Now, if you want to preserve the old Formatter behavior (without the space), you can change the Space after keyword <\/em>setting to No<\/em> in Preferences | Editor | Code Style | SQL (<\/em>go to the Queries <\/em>tab).<\/em><\/p>\n\n\n\n The other fixes in this area are more or less self-explanatory:<\/p>\n\n\n\n DBE-16831<\/a>: A setting to specify the default resolve mode used in the console has been added to Preferences | Database | Query execution | Other.<\/em> <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n That’s it for now! Get the EAP 1 build<\/a> and try working in DataGrip without these nagging issues. And let us know what you think in the comments below! <\/p>\n\n\n\n <\/p>\n","protected":false},"author":1294,"featured_media":323179,"comment_status":"closed","ping_status":"closed","template":"","categories":[826,89],"tags":[],"cross-post-tag":[],"acf":[],"_links":{"self":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip\/323123"}],"collection":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip"}],"about":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/types\/datagrip"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/users\/1294"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/comments?post=323123"}],"version-history":[{"count":10,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip\/323123\/revisions"}],"predecessor-version":[{"id":627236,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip\/323123\/revisions\/627236"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/media\/323179"}],"wp:attachment":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/media?parent=323123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/categories?post=323123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/tags?post=323123"},{"taxonomy":"cross-post-tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/cross-post-tag?post=323123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/figure>\n\n\n\n\n
<\/figure>\n\n\n\n\n
Database explorer<\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\n\n
Introspection<\/h3>\n\n\n\n
\n
Connectivity<\/h3>\n\n\n\n
\n
Object editor<\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\n\n
Data editor\/viewer<\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\n\n
<\/figure>\n\n\n\nQuery console<\/h3>\n\n\n\n
\n
SQL Resolve<\/h3>\n\n\n\n
<\/p>\n\n\n\n\n
– Public synonyms are now correctly placed in the PUBLIC schema.
– Recursive references to nested routines are resolved correctly.
– Cursor parameter references qualified by a cursor name are resolved correctly.
– Incorrect usages of %TYPE are reported as warnings.<\/li>\n\n\n\nExplain plan<\/h3>\n\n\n\n
\n
Navigation and search<\/h3>\n\n\n\n
\n
\n\n\n\n\n