SawitDB v2.3

Release SawitDB v2.3

New Features

• Generic SQL Support: Added full support for standard SQL syntax alongside AQL.
  • CREATE TABLE, INSERT INTO, SELECT, UPDATE, DELETE, DROP.
  • CREATE INDEX ON table (field) syntax.
• Advanced Operators:
  • IN (...), NOT IN (...)
  • LIKE 'pattern%' (Wildcard)
  • BETWEEN min AND max
  • IS NULL, IS NOT NULL
• Pagination & Sorting:
  • ORDER BY field [ASC|DESC]
  • LIMIT n OFFSET m
• Native Data Types: Improved INSERT parser to correctly handle NULL, TRUE, FALSE (boolean/null) instead of strings.

Performance

• Tokenizer Optimization: Fixed Regex parser to correctly identify < and > operators.
• Benchmark:
  • INSERT: ~3,125 ops/sec
  • SELECT (PK): ~3,846 ops/sec
  • SELECT (Scan): ~4,762 ops/sec
  • UPDATE: ~3,571 ops/sec

Bug Fixes

• Fixed "Normal Ops" parser fallthrough bug where simple comparisons (>, <) were sometimes misidentified.
• Fixed CREATE INDEX parser hanging code block.