sqlparser/dialect/
sqlite.rs

1// Licensed under the Apache License, Version 2.0 (the "License");
2// you may not use this file except in compliance with the License.
3// You may obtain a copy of the License at
4//
5// http://www.apache.org/licenses/LICENSE-2.0
6//
7// Unless required by applicable law or agreed to in writing, software
8// distributed under the License is distributed on an "AS IS" BASIS,
9// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
10// See the License for the specific language governing permissions and
11// limitations under the License.
12
13use crate::ast::Statement;
14use crate::dialect::Dialect;
15use crate::keywords::Keyword;
16use crate::parser::{Parser, ParserError};
17
18/// A [`Dialect`] for [SQLite](https://www.sqlite.org)
19#[derive(Debug)]
20pub struct SQLiteDialect {}
21
22impl Dialect for SQLiteDialect {
23    // see https://www.sqlite.org/lang_keywords.html
24    // parse `...`, [...] and "..." as identifier
25    // TODO: support depending on the context tread '...' as identifier too.
26    fn is_delimited_identifier_start(&self, ch: char) -> bool {
27        ch == '`' || ch == '"' || ch == '['
28    }
29
30    fn is_identifier_start(&self, ch: char) -> bool {
31        // See https://www.sqlite.org/draft/tokenreq.html
32        ch.is_ascii_lowercase()
33            || ch.is_ascii_uppercase()
34            || ch == '_'
35            || ch == '$'
36            || ('\u{007f}'..='\u{ffff}').contains(&ch)
37    }
38
39    fn supports_filter_during_aggregation(&self) -> bool {
40        true
41    }
42
43    fn is_identifier_part(&self, ch: char) -> bool {
44        self.is_identifier_start(ch) || ch.is_ascii_digit()
45    }
46
47    fn parse_statement(&self, parser: &mut Parser) -> Option<Result<Statement, ParserError>> {
48        if parser.parse_keyword(Keyword::REPLACE) {
49            parser.prev_token();
50            Some(parser.parse_insert())
51        } else {
52            None
53        }
54    }
55
56    fn supports_in_empty_list(&self) -> bool {
57        true
58    }
59}
sqlparser/dialect/sqlite.rs

sqlparser/dialect/
sqlite.rs
