oak-sql 0.0.11

SQL database query language parser with support for standard SQL syntax and database operations.
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68

#![doc = include_str!("readme.md")]
use oak_core::{Language, LanguageCategory};

/// SQL language implementation.
#[derive(Debug, Clone, Copy, PartialEq, Eq, Hash)]
#[cfg_attr(feature = "serde", derive(serde::Serialize, serde::Deserialize))]
pub struct SqlLanguage {
    /// Whether it is case sensitive.
    pub case_sensitive: bool,
    /// Whether to allow double-quoted identifiers.
    pub quoted_identifiers: bool,
    /// Whether to allow backtick identifiers.
    pub backtick_identifiers: bool,
    /// Whether to allow bracket identifiers.
    pub bracket_identifiers: bool,
}

impl SqlLanguage {
    /// Creates a new SQL language instance.
    pub fn new() -> Self {
        Self::default()
    }

    /// Creates a standard SQL language instance.
    pub fn standard() -> Self {
        Self::default()
    }

    /// Creates a MySQL-style SQL language instance.
    pub fn mysql() -> Self {
        Self { case_sensitive: false, quoted_identifiers: true, backtick_identifiers: true, bracket_identifiers: false }
    }

    /// Creates a PostgreSQL-style SQL language instance.
    pub fn postgresql() -> Self {
        Self { case_sensitive: false, quoted_identifiers: true, backtick_identifiers: false, bracket_identifiers: false }
    }

    /// SQLite configuration.
    pub fn sqlite() -> Self {
        Self {
            case_sensitive: false,
            quoted_identifiers: true,
            backtick_identifiers: true, // SQLite supports backticks
            bracket_identifiers: true,  // SQLite supports [bracket] identifiers
        }
    }

    /// Creates a SQL Server-style SQL language instance.
    pub fn sqlserver() -> Self {
        Self { case_sensitive: false, quoted_identifiers: true, backtick_identifiers: false, bracket_identifiers: true }
    }
}

impl Default for SqlLanguage {
    fn default() -> Self {
        Self { case_sensitive: false, quoted_identifiers: true, backtick_identifiers: false, bracket_identifiers: false }
    }
}

impl Language for SqlLanguage {
    const NAME: &'static str = "sql";
    const CATEGORY: LanguageCategory = LanguageCategory::Dsl;

    type TokenType = crate::lexer::token_type::SqlTokenType;
    type ElementType = crate::parser::element_type::SqlElementType;
    type TypedRoot = crate::ast::SqlRoot;
}