Editorial Note: This article is written with editorial review and topic relevance in mind.
Cte completion and navigation support was significantly improved sql columns completion was fixed (issue with overlapping names) added support of straight_join. Added a suggestion to check spatial column visibility when enabling the spatial view data cells search algorithm fixed (find/replace) sql editor: A warning is now shown instead of an error when a drop table statement contains if exists and the table does not exist fixed script execution on.
Mary Woolley Obituary (2020) Beaver County, Pennsylvania The Beaver
Fixed autocomplete for tables which names conflicts with keywords fixed where keyword autocompletion fixed collapse/expand of result tabs ceil and ceiling are no. When an inline editor is active and the user starts typing, the grid. Added support for common table expressions (cte) by semantic analysis and autocompletion data editor:
If referenced table has an alias, it’s now always prepended before column name for semantic completion added a new setting for semantic.
Added the ability to sort data by the primary key (preferences editors data editor default ordering) fixed data types coloring for foreign and primary keys sql editor: Tables with foreign keys are now displayed at the top of the autocompletion list fixed foreign key conditions and join suggestions for subqueries sql processing settings were. Fixed an issue when files modified externally could not be closed without. Ai integration is now included in the community packaging, extension install is not needed anymore sql editor:
