sqlparser

KO | EN

gitlite — search

#python #hacktoberfest #ai #typescript #llm #go #machine-learning #rust #linux #macos #cli #kubernetes #security #openai

(★ 10)

Extensible SQL Lexer and Parser for MoonBit

sqlparser 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Extensible SQL Lexer and Parser for MoonBit

A comprehensive SQL parser library for MoonBit that supports multiple SQL dialects and all major SQL language categories.

## Example Usage

```moonbit
// Parse a simple SELECT statement
let sql = "SELECT name, age FROM users WHERE age > 18"
let statements = parse_sql(sql)
let pretty_output = statements.stmts[0] |> pretty_print
println(pretty_output)

// Parse complex queries with CTEs
let complex_sql = """
WITH sales AS (
  SELECT user_id, SUM(amount) as total
  FROM orders 
  WHERE date > '2023-01-01'
  GROUP BY user_id
)
SELECT u.name, s.total
FROM users u
JOIN sales s ON u.id = s.user_id
ORDER BY s.total DESC
LIMIT 10
"""
let result = parse_sql(complex_sql)

// Parse transaction control statements
let tcl_sql = "BEGIN TRANSACTION; INSERT INTO users VALUES ('Alice'); COMMIT;"
let tcl_statements = parse_sql(tcl_sql)

// Parse data control statements
let dcl_sql = "GRANT SELECT, INSERT ON users TO alice WITH GRANT OPTION"
let dcl_result = parse_sql(dcl_sql)

// Dialect-specific parsing
let mysql_sql = "SHOW TABLES LIKE 'user%'"
let mysql_result = parse_sql(dialect=MySQL::{}, mysql_sql)
```

## Architecture

The parser follows a modular design:

- **Lexer** (`lexer.mbt`): Tokenizes SQL input with dialect-aware keyword recognition
- **Parser** (`parser.mbt`): Main parsing logic with statement dispatching
- **AST** (`ast.mbt`): Complete Abstract Syntax Tree definitions with pretty printing
- **Dialect Modules**: Separate modules for each SQL dialect (`mysql.mbt`, `postgres.mbt`, etc.)
- **Language Modules**: 
  - `dml.mbt`: Data Manipulation Language parsing
  - `ddl.mbt`: Data Definition Language parsing  
  - `tcl.mbt`: Transaction Control Language parsing
  - `dcl.mbt`: Data Control Language parsing

## Testing

The library includes comprehensive test coverage with 284+ tests covering:

- All SQL statement types across all language categories
- Dialect-specific features and syntax variations
- Complex expressions and nested queries
- Edge cases and error handling
- Pretty printing accuracy

Run tests with:
```bash
moon test
```

## Contributing

The parser is designed for extensibility. To add new SQL features:

1. Add keywords to `keyword.mbt` and `lexer.mbt`
2. Define AST structures in `ast.mbt` 
3. Implement parsing logic in appropriate language module
4. Add statement cases to `parser.mbt`
## Contributing

The parser is designed for extensibility. To add new SQL features:

1. Add keywords to `keyword.mbt` and `lexer.mbt`
2. Define AST structures in `ast.mbt` 
3. Implement parsing logic in appropriate language module
4. Add statement cases to `parser.mbt`
5. Write comprehensive tests

See [ROADMAP.md](ROADMAP.md) for planned features and implementation priorities.

## License

This project is licensed under the Apache 2.0 License.

sqlparser

sqlparser 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

sqlparser

sqlparser 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README