sqlglot-rust 0.9.27

A SQL parser, optimizer, and transpiler library inspired by Python's sqlglot
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

mod sql_parser;

pub use sql_parser::Parser;

use crate::ast::Statement;
use crate::dialects::Dialect;
use crate::errors::Result;

/// Parse a SQL string into a [`Statement`] AST using the given dialect.
///
/// # Errors
///
/// Returns a [`SqlglotError`](crate::errors::SqlglotError) if the input
/// is not valid SQL.
pub fn parse(sql: &str, _dialect: Dialect) -> Result<Statement> {
    let mut parser = Parser::new(sql)?;
    parser.parse_statement()
}

/// Parse a SQL string into a [`Statement`] AST, preserving SQL comments.
///
/// Comments are attached to the nearest AST node and survive through
/// transformation and generation.
///
/// # Errors
///
/// Returns a [`SqlglotError`](crate::errors::SqlglotError) if the input
/// is not valid SQL.
pub fn parse_with_comments(sql: &str, _dialect: Dialect) -> Result<Statement> {
    let mut parser = Parser::new_with_comments(sql)?;
    parser.parse_statement()
}

/// Parse a SQL string containing multiple statements separated by semicolons.
///
/// # Errors
///
/// Returns a [`SqlglotError`](crate::errors::SqlglotError) if parsing fails.
pub fn parse_statements(sql: &str, _dialect: Dialect) -> Result<Vec<Statement>> {
    let mut parser = Parser::new(sql)?;
    parser.parse_statements()
}

/// Parse multiple semicolon-separated SQL statements, preserving comments.
///
/// # Errors
///
/// Returns a [`SqlglotError`](crate::errors::SqlglotError) if parsing fails.
pub fn parse_statements_with_comments(sql: &str, _dialect: Dialect) -> Result<Vec<Statement>> {
    let mut parser = Parser::new_with_comments(sql)?;
    parser.parse_statements()
}