0.0.18 • Published 5 months ago
@hackolade/sql-select-statement-parser v0.0.18
SELECT statement SQL parser
Dialect-agnostic parser of SQL SELECT statements.
Function parseSelectStatement accepts SQL SELECT statement of different SQL dialects (MySQL, Oracle, PostgreSQL, T-SQL, Snowflake, etc.) and returns object describing columns and tables names used in the query.
Installation
npm install @hackolade/sql-select-statement-parser
Usage
const result = parseSelectStatement(`
SELECT "database".'schema'.table.[column] AS columnAlias
FROM database.schema.table AS tableAlias;
`);
Result structure
{
selectItems: [{ // array of selected columns and expressions
name: "column", // column name or *
tableName: "table", // table name
schemaName: "schema", // schema name (or database name for some dialects)
databaseName: "database", // database name (if schema also exists in the dialect)
originalName: "[column]", // original column name including quotes
// (or square brackets for T-SQL)
alias: "columnAlias", // column alias
fieldReferences: ["column"], // List of column names used in expression.
// Appears only when selected item is
// described by expression.
}],
from: [{ // array of tables described in a FROM clause
table: "table", // table name
schemaName: "schema", // schema name (or database name for some dialects)
databaseName: "database", // database name (if schema also exists in the dialect)
alias: "tableAlias", // table alias
originalName: "`table`", // original table name including quotes
//(or square brackets for T-SQL)
}]
}
License
0.0.18
5 months ago
0.0.15
5 months ago
0.0.16
5 months ago
0.0.17
5 months ago
0.0.14
5 months ago
0.0.11
9 months ago
0.0.12
6 months ago
0.0.13
5 months ago
0.0.10
1 year ago
0.0.9
2 years ago
0.0.8
2 years ago
0.0.3
2 years ago
0.0.5
2 years ago
0.0.4
2 years ago
0.0.7
2 years ago
0.0.6
2 years ago
0.0.2
2 years ago
0.0.1
2 years ago