ajitpratap0/GoSQLX

What's New in v1.8.0

The biggest GoSQLX release yet — 76 commits, 30+ PRs since v1.7.0.

🆕 Dialect Engine & Multi-Dialect Support

• Dialect Mode Engine — runtime dialect selection for parsing, validation, and formatting
• MySQL Support — LIMIT offset, count, REPLACE INTO, backtick identifiers, AUTO_INCREMENT, UNSIGNED, ZEROFILL, IF(), GROUP_CONCAT(), STRAIGHT_JOIN, USE INDEX/FORCE INDEX/IGNORE INDEX, INSERT IGNORE
• SQL Server (T-SQL) Support — SELECT TOP N, WITH (NOLOCK) table hints, CROSS/OUTER APPLY, MERGE with OUTPUT, square bracket identifiers [column], @@ROWCOUNT/@@IDENTITY globals, N'unicode' strings, TOP WITH TIES, #temp/##global tables

🆕 WASM Build & Web Playground

• Browser-based SQL parsing via WebAssembly
• Zero-install playground for trying GoSQLX

🆕 Query Transform API

• Programmatic SQL rewriting: AddWhereCondition(), SetLimit(), AddOrderBy()
• Safe, AST-based transformations (not string manipulation)

🆕 Comment Preservation

• SQL comments retained in AST and round-tripped through formatting

🆕 AST-based Formatter

• Style presets, intelligent indentation
• DDL statement formatting support

⚡ Performance

• ~50% faster parsing via complete token type overhaul (string → int constants)
• 1.5M+ ops/sec peak, 1.46M+ sustained (30s load test)
• IsCompoundKeywordStart() now O(1) via cached map lookup
• gosqlx.Parse() now uses parser pool (60-80% memory reduction)
• gosqlx.Validate() uses fast-path (avoids full AST construction)

🔒 Security

• Enhanced SQL injection detection with LIKE/blind injection patterns
• AST-based security scanner (8 detection patterns)

🔧 Other Highlights

• Error recovery for multi-error parsing
• AST-to-SQL serialization with round-trip support
• Dollar-quoted string support (PostgreSQL)
• Schema-aware validation package
• Query optimization advisor
• Snowflake dialect support
• Python bindings foundation (CGo)
• GitHub Action for SQL lint/validation
• Fuzz testing in 4 packages, 84%+ test coverage
• Apache-2.0 relicense

⚠️ Breaking Changes

• Token type system overhaul — if you use low-level token.Type string comparisons, see MIGRATION.md for upgrade guide
• High-level API (gosqlx.Parse(), gosqlx.Validate()) is fully backward compatible

Full Changelog: https://github.com/ajitpratap0/GoSQLX/compare/v1.7.0...v1.8.0

Upgrade

go get github.com/ajitpratap0/[email protected]
go install github.com/ajitpratap0/GoSQLX/cmd/[email protected]