ajitpratap0/GoSQLX

v1.7.0 Breaking

This release includes breaking changes for platform teams planning a safe upgrade.

Published 3mo Vulnerability Scanning

View tool

✓ No known CVEs patched

Read the diff → Tool health → What is this tool? →

✓ No known CVEs patched in this version

Topics

ast cli dialect go lsp mysql

+13 more

parser postgresql query-analyzer security sql sql-formatter sql-injection sql-linter sql-parser sql-validator sqlite wasm zero-copy

Summary

AI summary

Fixed schema‑qualified table names and double‑quoted identifiers in DML/DDL statements.

Full changelog

What's New in v1.7.0

Schema-Qualified Names

Full schema.table and db.schema.table support in SELECT, INSERT, UPDATE, DELETE, and all DDL statements
Backward-compatible: stored as dotted strings in existing Name fields

PostgreSQL Enhancements

Type Casting: :: operator (SELECT 1::int, col::text)
UPSERT: INSERT ... ON CONFLICT DO UPDATE/NOTHING
Positional Parameters: $1, $2 style placeholders
JSONB Operators: Additional @? and @@ operators
Regex Operators: ~, ~*, !~, !~* for pattern matching

Parser Enhancements (Batches 5-8)

ARRAY constructor expressions with subscript/slice operations
WITHIN GROUP clause for ordered-set aggregates
INTERVAL expressions (INTERVAL '1 day')
FOR UPDATE/SHARE row-level locking clauses
Multi-row INSERT VALUES
Enhanced BETWEEN support in expressions

Bug Fixes

Fixed schema-qualified table names (schema.table_name) causing E2002 errors (#202)
Fixed double-quoted identifiers in DML and DDL statements (#200)

Documentation

Updated SQL compatibility matrix, upgrade guide, and all version references
Comprehensive CHANGELOG with all 9 PRs documented

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

Upgrade

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

No breaking changes - fully backward compatible with v1.6.x.

View diff on GitHub

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

Share this release

Share on X Share on Bluesky

Track ajitpratap0/GoSQLX

Get notified when new releases ship.

About ajitpratap0/GoSQLX

7 SQL tools (validate, format, parse, lint, security scan, metadata extraction, full analysis) over Streamable HTTP. Public remote server at mcp.gosqlx.dev - no install needed. 1.25M+ ops/sec, 6 SQL dialects.

All releases →