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///
20/// This dialect allows columns in a
21/// [`CREATE TABLE`](https://sqlite.org/lang_createtable.html) statement with no
22/// type specified, as in `CREATE TABLE t1 (a)`. In the AST, these columns will
23/// have the data type [`Unspecified`](crate::ast::DataType::Unspecified).
24#[derive(Debug)]
25pub struct SQLiteDialect {}
26
27impl Dialect for SQLiteDialect {
28    // see https://www.sqlite.org/lang_keywords.html
29    // parse `...`, [...] and "..." as identifier
30    // TODO: support depending on the context tread '...' as identifier too.
31    fn is_delimited_identifier_start(&self, ch: char) -> bool {
32        ch == '`' || ch == '"' || ch == '['
33    }
34
35    fn is_identifier_start(&self, ch: char) -> bool {
36        // See https://www.sqlite.org/draft/tokenreq.html
37        ch.is_ascii_lowercase()
38            || ch.is_ascii_uppercase()
39            || ch == '_'
40            || ch == '$'
41            || ('\u{007f}'..='\u{ffff}').contains(&ch)
42    }
43
44    fn supports_filter_during_aggregation(&self) -> bool {
45        true
46    }
47
48    fn supports_start_transaction_modifier(&self) -> bool {
49        true
50    }
51
52    fn is_identifier_part(&self, ch: char) -> bool {
53        self.is_identifier_start(ch) || ch.is_ascii_digit()
54    }
55
56    fn parse_statement(&self, parser: &mut Parser) -> Option<Result<Statement, ParserError>> {
57        if parser.parse_keyword(Keyword::REPLACE) {
58            parser.prev_token();
59            Some(parser.parse_insert())
60        } else {
61            None
62        }
63    }
64
65    fn supports_in_empty_list(&self) -> bool {
66        true
67    }
68}
sqlparser/dialect/sqlite.rs

sqlparser/dialect/
sqlite.rs
