# lang-sql **Repository Path**: mirrors_codemirror/lang-sql ## Basic Information - **Project Name**: lang-sql - **Description**: SQL language support for the CodeMirror code editor - **Primary Language**: Unknown - **License**: MIT - **Default Branch**: main - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2020-12-30 - **Last Updated**: 2026-02-14 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # @codemirror/lang-sql [![NPM version](https://img.shields.io/npm/v/@codemirror/lang-sql.svg)](https://www.npmjs.org/package/@codemirror/lang-sql) [ [**WEBSITE**](https://codemirror.net/) | [**ISSUES**](https://github.com/codemirror/dev/issues) | [**FORUM**](https://discuss.codemirror.net/c/next/) | [**CHANGELOG**](https://github.com/codemirror/lang-sql/blob/main/CHANGELOG.md) ] This package implements SQL language support for the [CodeMirror](https://codemirror.net/) code editor. The [project page](https://codemirror.net/) has more information, a number of [examples](https://codemirror.net/examples/) and the [documentation](https://codemirror.net/docs/). This code is released under an [MIT license](https://github.com/codemirror/lang-sql/tree/main/LICENSE). We aim to be an inclusive, welcoming community. To make that explicit, we have a [code of conduct](http://contributor-covenant.org/version/1/1/0/) that applies to communication around the project. ## Usage ```javascript import {EditorView, basicSetup} from "codemirror" import {sql} from "@codemirror/lang-sql" const view = new EditorView({ parent: document.body, doc: `select * from users where age > 20`, extensions: [basicSetup, sql()] }) ``` Use `sql({dialect: PostgreSQL})` or similar to select a specific SQL dialect. ## API Reference

sql(config⁠?: SQLConfig = {}) → LanguageSupport

SQL language support for the given SQL dialect, with keyword completion, and, if provided, schema-based completion as extra extensions.

interface SQLConfig

Options used to configure an SQL extension.

dialect⁠?: SQLDialect: The dialect to use. Defaults to StandardSQL.
schema⁠?: SQLNamespace: You can use this to define the schemas, tables, and their fields for autocompletion.
defaultTable⁠?: string: When given, columns from the named table can be completed directly at the top level.
defaultSchema⁠?: string: When given, tables prefixed with this schema name can be completed directly at the top level.
upperCaseKeywords⁠?: boolean: When set to true, keyword completions will be upper-case.
keywordCompletion⁠?: fn(label: string, type: string) → Completion: Can be used to customize the completions generated for keywords.

type SQLNamespace = Object<SQLNamespace> | {self: Completion, children: SQLNamespace} | readonly (string | Completion)[]

The type used to describe a level of the schema for completion. Can be an array of options (columns), an object mapping table or schema names to deeper levels, or a {self, children} object that assigns a completion option to use for its parent property, when the default option (its name as label and type "type") isn't suitable.

class SQLDialect

Represents an SQL dialect.

language: LRLanguage: The language for this dialect.
spec: SQLDialectSpec: The spec used to define this dialect.
extension: Extension: Returns the language for this dialect as an extension.
configureLanguage(options: ParserConfig, name⁠?: string) → SQLDialect: Reconfigure the parser used by this dialect. Returns a new dialect object.
static define(spec: SQLDialectSpec) → SQLDialect: Define a new dialect.

type SQLDialectSpec

Configuration for an SQL Dialect.

keywords⁠?: string: A space-separated list of keywords for the dialect.
builtin⁠?: string: A space-separated string of built-in identifiers for the dialect.
types⁠?: string: A space-separated string of type names for the dialect.
backslashEscapes⁠?: boolean: Controls whether regular strings allow backslash escapes.
hashComments⁠?: boolean: Controls whether # creates a line comment.
slashComments⁠?: boolean: Controls whether // creates a line comment.
spaceAfterDashes⁠?: boolean: When enabled -- comments are only recognized when there's a space after the dashes.
doubleDollarQuotedStrings⁠?: boolean: When enabled, things quoted with "$" are treated as strings, rather than identifiers.
doubleQuotedStrings⁠?: boolean: When enabled, things quoted with double quotes are treated as strings, rather than identifiers.
charSetCasts⁠?: boolean: Enables strings like _utf8'str' or N'str'.
plsqlQuotingMechanism⁠?: boolean: Enables string quoting syntax like q'[str]', as used in PL/SQL.
operatorChars⁠?: string: The set of characters that make up operators. Defaults to "*+\-%<>!=&|~^/".
specialVar⁠?: string: The set of characters that start a special variable name. Defaults to "?".
identifierQuotes⁠?: string: The characters that can be used to quote identifiers. Defaults to "\"". Add [ for MSSQL-style bracket quoted identifiers.
caseInsensitiveIdentifiers⁠?: boolean: Controls whether identifiers are case-insensitive. Identifiers with upper-case letters are quoted when set to false (which is the default).
unquotedBitLiterals⁠?: boolean: Controls whether bit values can be defined as 0b1010. Defaults to false.
treatBitsAsBytes⁠?: boolean: Controls whether bit values can contain other characters than 0 and 1. Defaults to false.

StandardSQL: SQLDialect