sqltk_parser/dialect/
mssql.rs

1// Licensed to the Apache Software Foundation (ASF) under one
2// or more contributor license agreements.  See the NOTICE file
3// distributed with this work for additional information
4// regarding copyright ownership.  The ASF licenses this file
5// to you under the Apache License, Version 2.0 (the
6// "License"); you may not use this file except in compliance
7// with the License.  You may obtain a copy of the License at
8//
9//   http://www.apache.org/licenses/LICENSE-2.0
10//
11// Unless required by applicable law or agreed to in writing,
12// software distributed under the License is distributed on an
13// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
14// KIND, either express or implied.  See the License for the
15// specific language governing permissions and limitations
16// under the License.
17
18use crate::dialect::Dialect;
19
20/// A [`Dialect`] for [Microsoft SQL Server](https://www.microsoft.com/en-us/sql-server/)
21#[derive(Debug)]
22pub struct MsSqlDialect {}
23
24impl Dialect for MsSqlDialect {
25    fn is_delimited_identifier_start(&self, ch: char) -> bool {
26        ch == '"' || ch == '['
27    }
28
29    fn is_identifier_start(&self, ch: char) -> bool {
30        // See https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-2017#rules-for-regular-identifiers
31        ch.is_alphabetic() || ch == '_' || ch == '#' || ch == '@'
32    }
33
34    fn is_identifier_part(&self, ch: char) -> bool {
35        ch.is_alphabetic()
36            || ch.is_ascii_digit()
37            || ch == '@'
38            || ch == '$'
39            || ch == '#'
40            || ch == '_'
41    }
42
43    /// SQL Server has `CONVERT(type, value)` instead of `CONVERT(value, type)`
44    /// <https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16>
45    fn convert_type_before_value(&self) -> bool {
46        true
47    }
48
49    fn supports_connect_by(&self) -> bool {
50        true
51    }
52
53    fn supports_eq_alias_assignment(&self) -> bool {
54        true
55    }
56
57    fn supports_try_convert(&self) -> bool {
58        true
59    }
60}
sqltk_parser/dialect/mssql.rs

sqltk_parser/dialect/
mssql.rs
