sqlparser/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_outer_join_operator(&self) -> bool {
50        true
51    }
52
53    fn supports_connect_by(&self) -> bool {
54        true
55    }
56
57    fn supports_eq_alias_assignment(&self) -> bool {
58        true
59    }
60
61    fn supports_try_convert(&self) -> bool {
62        true
63    }
64
65    /// In MSSQL, there is no boolean type, and `true` and `false` are valid column names
66    fn supports_boolean_literals(&self) -> bool {
67        false
68    }
69
70    fn supports_named_fn_args_with_colon_operator(&self) -> bool {
71        true
72    }
73
74    fn supports_named_fn_args_with_expr_name(&self) -> bool {
75        true
76    }
77
78    fn supports_named_fn_args_with_rarrow_operator(&self) -> bool {
79        false
80    }
81
82    fn supports_start_transaction_modifier(&self) -> bool {
83        true
84    }
85    fn supports_end_transaction_modifier(&self) -> bool {
86        true
87    }
88
89    /// See: <https://learn.microsoft.com/en-us/sql/t-sql/statements/set-statements-transact-sql>
90    fn supports_set_stmt_without_operator(&self) -> bool {
91        true
92    }
93
94    /// See: <https://learn.microsoft.com/en-us/sql/relational-databases/tables/querying-data-in-a-system-versioned-temporal-table>
95    fn supports_timestamp_versioning(&self) -> bool {
96        true
97    }
98}
sqlparser/dialect/mssql.rs

sqlparser/dialect/
mssql.rs
