sqlparser/dialect/
mssql.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::dialect::Dialect;
14
15/// A [`Dialect`] for [Microsoft SQL Server](https://www.microsoft.com/en-us/sql-server/)
16#[derive(Debug)]
17pub struct MsSqlDialect {}
18
19impl Dialect for MsSqlDialect {
20    fn is_delimited_identifier_start(&self, ch: char) -> bool {
21        ch == '"' || ch == '['
22    }
23
24    fn is_identifier_start(&self, ch: char) -> bool {
25        // See https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-2017#rules-for-regular-identifiers
26        ch.is_alphabetic() || ch == '_' || ch == '#' || ch == '@'
27    }
28
29    fn is_identifier_part(&self, ch: char) -> bool {
30        ch.is_alphabetic()
31            || ch.is_ascii_digit()
32            || ch == '@'
33            || ch == '$'
34            || ch == '#'
35            || ch == '_'
36    }
37
38    fn supports_substring_from_for_expr(&self) -> bool {
39        false
40    }
41}