Typescript and monaco definitions for Google SQL.
This package is
hosted on npm, so can be
installed with npm
or an equivalent package manager.
npm i @google/google-sql-syntax-ts
Example usage:
import { QueryFormatter, GoogleSqlDefinition } from "google-sql-syntax-ts";
const queryFormatter = new QueryFormatter(new GoogleSqlDefinition());
const formattedQuery = queryFormatter.formatQuery(
"SELECT column, REGEXP_CONTAINS(column, r'a') AS column_contains_a FROM `some-table` WHERE date > 1970-01-01"
);
The formatted query will look like:
SELECT
COLUMN,
REGEXP_CONTAINS(COLUMN, r'a') AS column_contains_a
FROM
`some-table`
WHERE
date > 1970-01-01
googleSqlLanguageConfiguration
is exported, which can be used as a
language configuration for the Monaco Editor.