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    /// SQL Server has `CONVERT(type, value)` instead of `CONVERT(value, type)`
39    /// <https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16>
40    fn convert_type_before_value(&self) -> bool {
41        true
42    }
43
44    fn supports_substring_from_for_expr(&self) -> bool {
45        false
46    }
47}
sqlparser/dialect/mssql.rs

sqlparser/dialect/
mssql.rs
