IslandSQL for VS Code

This extension integrates a language server for IslandSQL (islandsql) in Visual Studio Code. IslandSQL parses files associated with the embedded SQL (sql) language and is compatible with the following optional extensions:

Extension	Language (Alias)
Oracle SQL Developer Extension for VS Code	PL/SQL (`oracle-sql`)
Oracle Developer Tools for VS Code (SQL and PLSQL)	Oracle-SQL and PLSQL (`oraclesql`)
SQLTools	SQL (`sql`)
Database Client	SQL (`sql`)
PostgreSQL by Chris Kolkman	Postgres (`postgres`)

The current islands of interests are DML statements of the following database management systems:

DBMS	Grammar Version
OracleDB	23.5
PostgreSQL	17

This extension is considered an early prototype of a language server integration in VS Code.

Features

Outline View

Show DML statements in SQL files.

outline view

Command "Find in DML..."

Find text in DML statements within SQL files. The serarch expression is a case-insensitive regular expression (dot matches new lines).

The result is shown in the explorer view in the sidebar.

result view

Requirements

JRE/JDK 11

Version 11 or newer is required. Java is used to start the language server process locally. If no javaBinDirectory is configured, the external command java must be found in the OS path.

Syntax Highlighting

This extension does not provide syntax highlighting. Associate the file/editor with another language such as SQL for syntax highlighting.

IslandSQL

phsalvisberg