You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This matrix documents the comprehensive SQL feature support in GoSQLX across different SQL dialects and standards. The testing was conducted using the comprehensive integration test suite with 700+ test cases covering real-world SQL patterns.
Recent Additions (v1.9.0)
✅ SQLite PRAGMA: Fully parsed — bare (PRAGMA x), arg (PRAGMA x(n)), and assignment (PRAGMA x=v) forms; PragmaStatement AST node
✅ WITHOUT ROWID: CREATE TABLE ... WITHOUT ROWID; reserved keywords now valid as DDL column names
❌ Not Supported: Feature not recognized or causes parsing errors
🔧 Syntax Only: Recognizes syntax but no semantic validation
Core SQL Features Support Matrix
Data Manipulation Language (DML)
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
SELECT
✅
✅
✅
✅
✅
✅ Full
100%
Basic WHERE clauses
✅
✅
✅
✅
✅
✅ Full
100%
Complex WHERE (nested)
✅
✅
✅
✅
✅
✅ Full
100%
ORDER BY
✅
✅
✅
✅
✅
✅ Full
100%
GROUP BY
✅
✅
✅
✅
✅
✅ Full
100%
HAVING
✅
✅
✅
✅
✅
✅ Full
100%
DISTINCT
✅
✅
✅
✅
✅
✅ Full
100%
LIMIT/TOP
✅
✅
✅
✅
✅
✅ Full
95%
FETCH FIRST (SQL-99 F861)
✅
✅
✅
✅
❌
✅ Full
95%
FETCH WITH TIES (SQL-99 F862)
✅
✅
✅
✅
❌
✅ Full
90%
OFFSET-FETCH pagination
✅
✅
✅
✅
❌
✅ Full
95%
INSERT
✅
✅
✅
✅
✅
✅ Full
100%
INSERT VALUES
✅
✅
✅
✅
✅
✅ Full
100%
INSERT SELECT
✅
✅
✅
✅
✅
✅ Full
100%
Multi-row INSERT
✅
✅
✅
✅
✅
✅ Full
100%
UPDATE
✅
✅
✅
✅
✅
✅ Full
100%
UPDATE with JOIN
✅
✅
✅
✅
❌
✅ Full
90%
Multi-table UPDATE
✅
✅
✅
✅
❌
✅ Full
80%
DELETE
✅
✅
✅
✅
✅
✅ Full
100%
DELETE with JOIN
✅
✅
✅
✅
❌
✅ Full
90%
TRUNCATE
✅
✅
✅
✅
✅
✅ Full
95%
TRUNCATE with CASCADE
✅
❌
❌
✅
❌
✅ Full
90%
MERGE (SQL:2003 F312)
✅
❌
✅
✅
❌
✅ Full
95%
MERGE WHEN MATCHED
✅
❌
✅
✅
❌
✅ Full
95%
MERGE WHEN NOT MATCHED
✅
❌
✅
✅
❌
✅ Full
95%
RETURNING Clause (PostgreSQL)
✅
❌
✅
✅
❌
✅ Full
95%
INSERT...RETURNING
✅
❌
✅
✅
❌
✅ Full
95%
UPDATE...RETURNING
✅
❌
✅
✅
❌
✅ Full
95%
DELETE...RETURNING
✅
❌
✅
✅
❌
✅ Full
95%
Data Definition Language (DDL)
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
CREATE TABLE
✅
✅
✅
✅
✅
✅ Full
100%
Column definitions
✅
✅
✅
✅
✅
✅ Full
100%
Primary keys
✅
✅
✅
✅
✅
✅ Full
100%
Foreign keys
✅
✅
✅
✅
✅
✅ Full
100%
Unique constraints
✅
✅
✅
✅
✅
✅ Full
100%
Check constraints
✅
✅
✅
✅
✅
✅ Full
95%
ALTER TABLE
✅
✅
✅
✅
✅
✅ Full
95%
ADD COLUMN
✅
✅
✅
✅
✅
✅ Full
100%
DROP COLUMN
✅
✅
✅
✅
✅
✅ Full
100%
MODIFY COLUMN
✅
✅
✅
✅
✅
✅ Full
95%
DROP TABLE
✅
✅
✅
✅
✅
✅ Full
100%
CREATE INDEX
✅
✅
✅
✅
✅
✅ Full
100%
Unique indexes
✅
✅
✅
✅
✅
✅ Full
100%
Partial indexes
✅
❌
⚠️
❌
✅
⚠️ Partial
40%
CREATE VIEW
✅
✅
✅
✅
✅
✅ Full
100%
CREATE MATERIALIZED VIEW
✅
❌
✅
✅
❌
✅ Full
95%
REFRESH MATERIALIZED VIEW
✅
❌
❌
✅
❌
✅ Full
95%
TABLE PARTITIONING
✅
✅
✅
✅
❌
✅ Full
90%
PARTITION BY RANGE
✅
✅
✅
✅
❌
✅ Full
90%
PARTITION BY LIST
✅
✅
✅
✅
❌
✅ Full
90%
PARTITION BY HASH
✅
✅
✅
✅
❌
✅ Full
90%
JOIN Operations
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
INNER JOIN
✅
✅
✅
✅
✅
✅ Full
100%
LEFT JOIN
✅
✅
✅
✅
✅
✅ Full
100%
RIGHT JOIN
✅
✅
✅
✅
❌
✅ Full
100%
FULL OUTER JOIN
✅
❌
✅
✅
❌
✅ Full
85%
CROSS JOIN
✅
✅
✅
✅
✅
✅ Full
100%
NATURAL JOIN
✅
✅
❌
✅
✅
✅ Full
95%
Multiple table JOINs
✅
✅
✅
✅
✅
✅ Full
100%
Self JOINs
✅
✅
✅
✅
✅
✅ Full
100%
LATERAL JOIN (PostgreSQL)
✅
❌
❌
❌
❌
✅ Full
95%
LATERAL with LEFT JOIN
✅
❌
❌
❌
❌
✅ Full
95%
LATERAL with INNER JOIN
✅
❌
❌
❌
❌
✅ Full
95%
LATERAL with CROSS JOIN
✅
❌
❌
❌
❌
✅ Full
95%
JOIN with USING clause
✅
✅
❌
✅
✅
✅ Full
95%
Subqueries
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
Scalar subqueries
✅
✅
✅
✅
✅
✅ Full
100%
Table subqueries
✅
✅
✅
✅
✅
✅ Full
100%
Correlated subqueries
✅
✅
✅
✅
✅
✅ Full
100%
EXISTS
✅
✅
✅
✅
✅
✅ Full
100%
NOT EXISTS
✅
✅
✅
✅
✅
✅ Full
100%
IN (subquery)
✅
✅
✅
✅
✅
✅ Full
100%
ANY/SOME
✅
✅
✅
✅
✅
✅ Full
95%
ALL
✅
✅
✅
✅
✅
✅ Full
95%
Aggregate Functions
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
COUNT
✅
✅
✅
✅
✅
✅ Full
100%
SUM
✅
✅
✅
✅
✅
✅ Full
100%
AVG
✅
✅
✅
✅
✅
✅ Full
100%
MIN/MAX
✅
✅
✅
✅
✅
✅ Full
100%
FILTER Clause (SQL:2003)
✅
❌
❌
✅
❌
✅ Full
95%
COUNT(*) FILTER (WHERE...)
✅
❌
❌
✅
❌
✅ Full
95%
Aggregate ORDER BY (PostgreSQL)
✅
❌
❌
❌
❌
✅ Full
95%
GROUP_CONCAT
❌
✅
❌
❌
✅
✅ Full
95%
STRING_AGG
✅
❌
✅
✅
❌
✅ Full
90%
ARRAY_AGG
✅
❌
❌
✅
❌
✅ Full
90%
Advanced SQL Features
Common Table Expressions (CTEs)
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
Basic CTE (WITH clause)
✅
✅
✅
✅
✅
✅ Full
100%
Multiple CTEs
✅
✅
✅
✅
✅
✅ Full
100%
Recursive CTE
✅
✅
✅
✅
✅
✅ Full
100%
Nested CTEs
✅
✅
✅
✅
✅
✅ Full
95%
Materialized CTE Hints
✅
❌
❌
❌
❌
✅ Full
90%
WITH...AS MATERIALIZED
✅
❌
❌
❌
❌
✅ Full
90%
WITH...AS NOT MATERIALIZED
✅
❌
❌
❌
❌
✅ Full
90%
Window Functions
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
ROW_NUMBER()
✅
✅
✅
✅
✅
✅ Full
100%
RANK()
✅
✅
✅
✅
✅
✅ Full
100%
DENSE_RANK()
✅
✅
✅
✅
✅
✅ Full
100%
NTILE()
✅
✅
✅
✅
✅
✅ Full
100%
LAG/LEAD
✅
✅
✅
✅
✅
✅ Full
100%
FIRST_VALUE/LAST_VALUE
✅
✅
✅
✅
✅
✅ Full
100%
NTH_VALUE
✅
✅
✅
✅
✅
✅ Full
95%
PARTITION BY
✅
✅
✅
✅
✅
✅ Full
100%
ORDER BY in window
✅
✅
✅
✅
✅
✅ Full
100%
ROWS frame
✅
✅
✅
✅
✅
✅ Full
95%
RANGE frame
✅
✅
✅
✅
✅
✅ Full
90%
Frame UNBOUNDED PRECEDING
✅
✅
✅
✅
✅
✅ Full
95%
Frame UNBOUNDED FOLLOWING
✅
✅
✅
✅
✅
✅ Full
95%
Frame CURRENT ROW
✅
✅
✅
✅
✅
✅ Full
95%
Frame N PRECEDING/FOLLOWING
✅
✅
✅
✅
✅
✅ Full
90%
Set Operations
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
UNION
✅
✅
✅
✅
✅
✅ Full
100%
UNION ALL
✅
✅
✅
✅
✅
✅ Full
100%
INTERSECT
✅
❌
✅
✅
✅
✅ Full
90%
EXCEPT/MINUS
✅
❌
✅
✅
❌
✅ Full
90%
Grouping Operations (SQL-99 T431)
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
GROUPING SETS
✅
✅
✅
✅
❌
✅ Full
95%
ROLLUP
✅
✅
✅
✅
❌
✅ Full
95%
CUBE
✅
✅
✅
✅
❌
✅ Full
95%
Combined GROUPING SETS
✅
✅
✅
✅
❌
✅ Full
90%
GROUPING() function
✅
✅
✅
✅
❌
✅ Full
90%
ORDER BY Extensions (SQL-99 F851)
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
NULLS FIRST
✅
❌
❌
✅
❌
✅ Full
95%
NULLS LAST
✅
❌
❌
✅
❌
✅ Full
95%
Multiple columns with NULLS
✅
❌
❌
✅
❌
✅ Full
90%
Expression Operators
Feature
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
GoSQLX Parser
Test Coverage
BETWEEN...AND
✅
✅
✅
✅
✅
✅ Full
100%
NOT BETWEEN
✅
✅
✅
✅
✅
✅ Full
100%
IN (list)
✅
✅
✅
✅
✅
✅ Full
100%
IN (subquery)
✅
✅
✅
✅
✅
✅ Full
100%
NOT IN
✅
✅
✅
✅
✅
✅ Full
100%
LIKE
✅
✅
✅
✅
✅
✅ Full
100%
NOT LIKE
✅
✅
✅
✅
✅
✅ Full
100%
IS NULL
✅
✅
✅
✅
✅
✅ Full
100%
IS NOT NULL
✅
✅
✅
✅
✅
✅ Full
100%
IS TRUE/FALSE
✅
✅
❌
❌
✅
✅ Full
90%
Dialect-Specific Features
Note: This section documents dialect-specific features where "Support Level" refers to the native database's support, while "GoSQLX Parser" and "Test Coverage" indicate GoSQLX implementation status. Many features listed have keyword recognition only (🔧 Syntax) without full parsing logic.
PostgreSQL-Specific Features
Feature
Support Level
GoSQLX Parser
Test Coverage
Notes
Arrays
✅ Full
🔧 Syntax
40%
Keyword recognition only
JSON/JSONB Types
✅ Full
✅ Full
95%
Full type support
JSON -> Operator
✅ Full
✅ Full
95%
Extract JSON field as JSON
JSON ->> Operator
✅ Full
✅ Full
95%
Extract JSON field as text
JSON #> Operator
✅ Full
✅ Full
95%
Extract nested JSON path as JSON
JSON #>> Operator
✅ Full
✅ Full
95%
Extract nested JSON path as text
JSON @> Operator
✅ Full
✅ Full
95%
Contains (left contains right)
JSON <@ Operator
✅ Full
✅ Full
95%
Contained by (left contained by right)
JSON ? Operator
✅ Full
✅ Full
95%
Key exists
**JSON ?
Operator**
✅ Full
✅ Full
95%
JSON ?& Operator
✅ Full
✅ Full
95%
All keys exist
JSON #- Operator
✅ Full
✅ Full
95%
Delete path
DISTINCT ON
✅ Full
✅ Full
95%
SELECT DISTINCT ON (columns) ORDER BY...
FILTER Clause
✅ Full
✅ Full
95%
Aggregate FILTER (WHERE condition)
Aggregate ORDER BY
✅ Full
✅ Full
95%
string_agg(col, ',' ORDER BY col)
RETURNING Clause
✅ Full
✅ Full
95%
INSERT/UPDATE/DELETE RETURNING
Full-text search
✅ Full
🔧 Syntax
30%
tsvector, tsquery types
LATERAL Joins
✅ Full
✅ Full
95%
Full support with LEFT/INNER/CROSS variants
Custom operators
✅ Full
⚠️ Partial
30%
Basic operator recognition
Dollar quoting
✅ Full
✅ Full
90%
$$body$$ and $tag$body$tag$ (v1.8.0)
MySQL-Specific Features (Enhanced in v1.8.0)
Feature
Support Level
GoSQLX Parser
Test Coverage
Notes
SHOW statements
✅ Full
✅ Full
95%
SHOW TABLES, DATABASES, CREATE TABLE (v1.8.0)
DESCRIBE/EXPLAIN
✅ Full
✅ Full
95%
Table description commands (v1.8.0)
REPLACE INTO
✅ Full
✅ Full
95%
MySQL insert-or-replace (v1.8.0)
ON DUPLICATE KEY UPDATE
✅ Full
✅ Full
95%
MySQL upsert syntax (v1.8.0)
LIMIT offset, count
✅ Full
✅ Full
95%
MySQL-style LIMIT 10, 20 (v1.8.0)
UPDATE/DELETE with LIMIT
✅ Full
✅ Full
90%
MySQL extension (v1.8.0)
GROUP_CONCAT
✅ Full
✅ Full
95%
With ORDER BY and SEPARATOR (v1.8.0)
MATCH/AGAINST
✅ Full
✅ Full
95%
Full-text search (v1.8.0)
REGEXP/RLIKE
✅ Full
✅ Full
90%
Regular expression operators (v1.8.0)
INTERVAL number unit
✅ Full
✅ Full
90%
MySQL-style INTERVAL 30 DAY (v1.8.0)
IF()/REPLACE() as functions
✅ Full
✅ Full
85%
Keywords usable as function names (v1.8.0)
Storage engines
✅ Full
🔧 Syntax
80%
ENGINE=InnoDB syntax
Index hints
✅ Full
✅ Full
75%
USE/IGNORE/FORCE INDEX
Partitioning
✅ Full
🔧 Syntax
70%
PARTITION BY syntax
AUTO_INCREMENT
✅ Full
✅ Full
95%
Column property
Backtick identifiers
✅ Full
✅ Full
100%
`table`.`column` syntax
SQL Server-Specific Features
Feature
Support Level
GoSQLX Parser
Test Coverage
Notes
MERGE
✅ Full
✅ Full
95%
MERGE statements with WHEN clauses
PIVOT/UNPIVOT
✅ Full
🔧 Syntax
10%
Keywords reserved, no parsing logic
CROSS/OUTER APPLY
✅ Full
🔧 Syntax
10%
Keywords reserved, no parsing logic
HierarchyID
✅ Full
🔧 Syntax
20%
Data type recognition
T-SQL functions
✅ Full
⚠️ Partial
40%
Subset of T-SQL functions
Oracle-Specific Features
Feature
Support Level
GoSQLX Parser
Test Coverage
Notes
CONNECT BY
✅ Full
🔧 Syntax
10%
Keywords reserved, no parsing logic
PRIOR operator
✅ Full
🔧 Syntax
10%
Keyword reserved, no parsing logic
DECODE function
✅ Full
⚠️ Partial
40%
Recognized as function, no special handling
NVL/NVL2
✅ Full
⚠️ Partial
40%
Recognized as function, no special handling
Dual table
✅ Full
✅ Full
100%
Standard table reference
Analytic functions
✅ Full
⚠️ Partial
60%
Subset via window functions
SQLite-Specific Features
Feature
Support Level
GoSQLX Parser
Test Coverage
Notes
PRAGMA
✅ Full
✅ Full
90%
Bare, arg, and assignment forms fully parsed
ATTACH/DETACH
✅ Full
🔧 Syntax
10%
Keywords reserved, no parsing logic
Type affinity
✅ Full
⚠️ Partial
30%
Flexible typing
WITHOUT ROWID
✅ Full
✅ Full
85%
CREATE TABLE option fully supported
Simplified syntax
✅ Full
✅ Full
85%
SQLite variations
SQL Standards Compliance
SQL-92 (Entry Level)
Feature Category
Support Level
Test Coverage
Notes
Basic data types
✅ Full
100%
CHAR, VARCHAR, INTEGER, etc.
Basic predicates
✅ Full
100%
=, <>, <, >, <=, >=
Basic expressions
✅ Full
100%
Arithmetic, string operations
Subqueries
✅ Full
100%
WHERE and HAVING subqueries
Aggregate functions
✅ Full
100%
COUNT, SUM, AVG, MIN, MAX
Joins
✅ Full
95%
Inner and outer joins
UNION
✅ Full
100%
Set operations
SQL-99 (Core Features)
Feature Category
Support Level
Test Coverage
Notes
Regular expressions
⚠️ Partial
60%
SIMILAR TO operator
Array types
⚠️ Partial
40%
Limited array support
Common Table Expressions
✅ Full
100%
WITH clause
Window functions
✅ Full
95%
OVER clause
CASE expressions
✅ Full
100%
Simple and searched CASE
Recursive queries
✅ Full
100%
Recursive CTEs
SQL-2003 (XML Features)
Feature Category
Support Level
Test Coverage
Notes
Window functions
✅ Full
100%
Enhanced window support
MERGE statement
✅ Full
80%
UPSERT operations
Object identifiers
✅ Full
90%
Standardized identifiers
XML data type
🔧 Syntax
30%
Basic syntax recognition
XML functions
❌ Not Supported
0%
XMLQuery, XMLTable, etc.
SQL-2006 (Enhancement)
Feature Category
Support Level
Test Coverage
Notes
Enhanced window functions
✅ Full
95%
Additional frame options
More built-in functions
⚠️ Partial
70%
Subset of new functions
IMPORT/EXPORT
❌ Not Applicable
0%
Not relevant for parser
SQL-2008 (Enhancements)
Feature Category
Support Level
Test Coverage
Notes
INSTEAD OF triggers
🔧 Syntax
50%
Syntax recognition only
Enhanced MERGE
✅ Full
80%
Extended MERGE capabilities
TRUNCATE statement
✅ Full
95%
Full TRUNCATE support with CASCADE
FETCH FIRST/NEXT
✅ Full
95%
Standard row limiting (F861/F862)
SQL-2011 (Temporal Data)
Feature Category
Support Level
Test Coverage
Notes
Temporal tables
🔧 Syntax
30%
FOR SYSTEM_TIME syntax
Window function enhancements
⚠️ Partial
60%
Some new functions
SQL-2016 (JSON Support)
Feature Category
Support Level
Test Coverage
Notes
JSON data type
🔧 Syntax
40%
Type recognition
JSON functions
⚠️ Partial
20%
Limited function support
Row pattern recognition
❌ Not Supported
0%
MATCH_RECOGNIZE clause
v1.6.0 PostgreSQL Extension Summary
GoSQLX v1.6.0 introduces comprehensive PostgreSQL-specific feature support, making it one of the most PostgreSQL-compatible SQL parsers available.
Complete PostgreSQL Feature Set
Feature Category
Features Included
Support Level
Use Cases
JSON/JSONB
All 10 operators (->, ->>, #>, #>>, @>, <@, ?, `?
, ?&, #-`)
✅ Full
LATERAL Joins
LEFT LATERAL, INNER LATERAL, CROSS LATERAL
✅ Full
Correlated subqueries, row-level computations
DISTINCT ON
SELECT DISTINCT ON with ORDER BY
✅ Full
Deduplication, first/last row selection
FILTER Clause
Conditional aggregation on all aggregates
✅ Full
Multi-condition analytics in single query
Aggregate ORDER BY
Ordering within aggregate functions
✅ Full
String concatenation, array aggregation
RETURNING
INSERT/UPDATE/DELETE RETURNING
✅ Full
Audit trails, single-trip operations
JSON/JSONB Operator Examples
-- Extract field as JSON (->)SELECT data->'user'FROM events;
-- Extract field as text (->>)SELECT data->>'email'FROM users;
-- Extract nested path as JSON (#>)SELECT data#>'{user,address,city}' FROM profiles;-- Extract nested path as text (#>>)SELECT data#>>'{user,name}' FROM profiles;-- Contains (@>)SELECT*FROM products WHERE attributes @>'{"color": "red"}';
-- Contained by (<@)SELECT*FROM users WHERE tags <@ '["admin", "user"]';
-- Key exists (?)SELECT*FROM profiles WHERE data ? 'email';
-- Any key exists (?|)SELECT*FROM users WHERE profile ?| array['phone', 'mobile'];
-- All keys exist (?&)SELECT*FROM users WHERE profile ?& array['name', 'email'];
-- Delete path (#-)SELECT data #- '{user,temp}' FROM cache;
LATERAL JOIN Examples
-- Correlated subquery in FROM clauseSELECTu.name, recent.order_dateFROM users u,
LATERAL (
SELECT order_date FROM orders
WHERE user_id =u.idORDER BY order_date DESCLIMIT3
) recent;
-- LEFT LATERAL JOINSELECTu.name, stats.totalFROM users u
LEFT JOIN LATERAL (
SELECTSUM(amount) as total
FROM transactions
WHERE user_id =u.id
) stats ON true;
DISTINCT ON Examples
-- Get first row per departmentSELECT DISTINCTON (dept_id) dept_id, name, salary
FROM employees
ORDER BY dept_id, salary DESC;
-- Latest status per userSELECT DISTINCTON (user_id) user_id, status, updated_at
FROM user_status_log
ORDER BY user_id, updated_at DESC;
FILTER Clause Examples
-- Multi-condition aggregationSELECT
dept_id,
COUNT(*) FILTER (WHERE status ='active') AS active_count,
COUNT(*) FILTER (WHERE status ='inactive') AS inactive_count,
SUM(salary) FILTER (WHERE bonus_eligible = true) AS bonus_pool
FROM employees
GROUP BY dept_id;
RETURNING Clause Examples
-- INSERT with RETURNINGINSERT INTO users (name, email)
VALUES ('John Doe', 'john@example.com')
RETURNING id, created_at;
-- UPDATE with RETURNINGUPDATE products
SET price = price *1.1WHERE category ='Electronics'
RETURNING id, name, price;
-- DELETE with RETURNINGDELETEFROM sessions
WHERE expired_at < NOW()
RETURNING user_id, session_id;
Dialect Mode Engine (v1.8.0)
GoSQLX v1.8.0 introduces a first-class dialect mode engine that threads the SQL dialect through the tokenizer and parser. This enables dialect-specific keyword recognition, syntax parsing, and validation.
Supported Dialects
Dialect
Dialect String
Keyword Set
Dialect-Specific Parsing
Status
PostgreSQL
"postgresql"
Full PG keywords
::, ON CONFLICT, $$, JSONB ops, LATERAL, DISTINCT ON
✅ Default dialect
MySQL
"mysql"
MySQL keywords
SHOW, DESCRIBE, REPLACE INTO, ON DUPLICATE KEY, LIMIT n,m, GROUP_CONCAT, MATCH AGAINST, REGEXP