Valentina Studio Release 12.5.9 improves SQL Editor

Valentina Release 12.5.9 Improves Valentina Studio SQL Editor

Expanded recognition, suggestions based on reserved and key words.

Valentina Studio FREE | Single | PRO

Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

NOTE: This update focuses on technologies first implemented in Valentina Studio 9.6 and, which enable highly productive search and auto-completion functionality.

  • [Imp][SQL Editor] – Static Analyzer
    • Respects ‘CREATE DOMAIN’, ‘DROP DOMAIN’ commands.
    • Respects ‘CREATE SEQUENCE’, ‘DROP SEQUENCE’ commands.
    • SELECT tblAlias.fldName fldAlias
    • SELECT foo() fldAlias
  • [Imp][SQL Editor] – IdentResolver
    • DROP commands respect [IF EXISTS] clauses
  • [Imp][SQL Editor] – Auto-completion
    • More names of DB objects extracted now from the supported DBMS.
      • For example: TYPE in VDB, UNIQUE in SQLite, etc.
  • [Fix][SQL Editor] – Tip for a sequence name.

All product updates are available for immediate download from the Paradigma Software download site. See the original announcement on the forum.

Original release notes also available on the Valentina Wiki.