A JavaScript library for detecting SQL dialects based on query analysis, including keywords, expressions, and structures.
npm install sql-dialect-detectorSQL Dialect Detector is a powerful JavaScript library that detects the SQL dialect used in a given SQL query. It supports various SQL databases including PostgreSQL, MySQL, Oracle, SQL Server, SQLite, Amazon Redshift, Google BigQuery, and many more.
- Detects the SQL dialect based on keywords, built-in functions, and unique SQL structures.
- Supports a wide range of databases including:
- PostgreSQL
- MySQL
- SQL Server
- Oracle
- SQLite
- Amazon Redshift
- Google BigQuery
- IBM Db2
- Apache Hive
- Couchbase (N1QL)
- SingleStoreDB
- Snowflake
- Apache Spark
- Trino
- Amazon Athena
- Provides a confidence level for each detected dialect.
- Lightweight and easy to integrate.
To install the library, use npm:
``bash`
npm install sql-dialect-detector
Here's a simple example of how to use SQL Dialect Detector in your project:
`javascript
import SQLDialectDetector from 'sql-dialect-detector';
const sqlQuery =
SELECT COUNT(*) FROM users WHERE created_at > '2023-01-01';;
const detector = new SQLDialectDetector();
const detectedDialects = detector.detectSQLDialects(sqlQuery);
console.log(detectedDialects);
`
You can integrate the library into an HTML page as follows:
`html
SQL Dialect Detector
``
You can configure the library with different settings to optimize detection accuracy for your use case.
This project is licensed under the MIT License - see the LICENSE file for details.
Hien Tran