1pub const SELECT_KW: &str = "SELECT ";
2pub const FROM_KW: &str = " FROM ";
3pub const WHERE_KW: &str = " WHERE ";
4pub const ORDER_BY_KW: &str = " ORDER BY ";
5pub const GROUP_BY_KW: &str = " GROUP BY ";
6pub const HAVING_KW: &str = " HAVING ";
7pub const LIMIT_KW: &str = " LIMIT ";
8pub const OFFSET_KW: &str = " OFFSET ";
9
10pub const ASC: &str = " ASC";
11pub const DESC: &str = " DESC";
12
13pub const DISTINCT_KW: &str = "DISTINCT ";
14
15pub const INNER_JOIN: &str = " INNER JOIN ";
16pub const LEFT_OUTER_JOIN: &str = " LEFT OUTER JOIN ";
17pub const RIGHT_OUTER_JOIN: &str = " RIGHT OUTER JOIN ";
18pub const FULL_OUTER_JOIN: &str = " FULL OUTER JOIN ";
19pub const ON_KW: &str = " ON ";
20pub const ON_TRUE: &str = " ON 1";
21
22pub const AND_KW: &str = " AND ";
23pub const OR_KW: &str = " OR ";
24pub const EQ: &str = " = ";
25pub const NE: &str = " <> ";
26pub const LT: &str = " < ";
27pub const GT: &str = " > ";
28pub const LE: &str = " <= ";
29pub const GE: &str = " >= ";
30pub const LIKE: &str = " LIKE ";
31pub const NOT_LIKE: &str = " NOT LIKE ";
32pub const GLOB: &str = " GLOB ";
33
34pub const IS_NULL: &str = " IS NULL";
35pub const IS_NOT_NULL: &str = " IS NOT NULL";
36
37pub const IN_OPEN: &str = " IN (";
38pub const NOT_IN_OPEN: &str = " NOT IN (";
39
40pub const COUNT_STAR: &str = "COUNT(*)";
41pub const COUNT_OPEN: &str = "COUNT(";
42pub const SUM_OPEN: &str = "SUM(";
43pub const AVG_OPEN: &str = "AVG(";
44pub const MIN_OPEN: &str = "MIN(";
45pub const MAX_OPEN: &str = "MAX(";
46
47pub const ROW_NUMBER_OVER: &str = "ROW_NUMBER() OVER (";
48pub const RANK_OVER: &str = "RANK() OVER (";
49pub const DENSE_RANK_OVER: &str = "DENSE_RANK() OVER (";
50pub const COUNT_STAR_OVER: &str = "COUNT(*) OVER (";
51pub const OVER_OPEN: &str = ") OVER (";
52pub const PARTITION_BY: &str = "PARTITION BY ";
53pub const WIN_ORDER_BY: &str = "ORDER BY ";
54
55pub const INSERT_INTO_KW: &str = "INSERT INTO ";
56pub const VALUES_OPEN: &str = ") VALUES (";
57pub const ON_CONFLICT_DO_NOTHING: &str = " ON CONFLICT DO NOTHING";
58pub const RETURNING_KW: &str = " RETURNING ";
59pub const UPDATE_KW: &str = "UPDATE ";
60pub const SET_KW: &str = " SET ";
61pub const DELETE_FROM_KW: &str = "DELETE FROM ";
62
63pub const UNION_KW: &str = " UNION ";
64pub const UNION_ALL_KW: &str = " UNION ALL ";
65pub const INTERSECT_KW: &str = " INTERSECT ";
66pub const EXCEPT_KW: &str = " EXCEPT ";
67
68pub const WITH_KW: &str = "WITH ";
69pub const AS_OPEN: &str = " AS (";
70
71pub const EXISTS_OPEN: &str = "EXISTS (SELECT 1 FROM ";
72pub const NOT_EXISTS_OPEN: &str = "NOT EXISTS (SELECT 1 FROM ";
73pub const SUBQUERY_OPEN: &str = "(SELECT ";
74pub const SETOP_BRANCH_OPEN: &str = "SELECT ";
75pub const SETOP_BRANCH_CLOSE: &str = "";
76
77pub const JSON_GET: &str = " -> ";
78pub const JSON_GET_TEXT: &str = " ->> ";
79
80pub const CONCAT: &str = " || ";
81
82pub const COMMA: &str = ", ";
83pub const COMMA_TIGHT: &str = ",";
84pub const SPACE: &str = " ";
85pub const PAREN_OPEN: &str = "(";
86pub const PAREN_CLOSE: &str = ")";
87pub const PAREN_OPEN_LEADING_SPACE: &str = " (";
88pub const PAREN_CLOSE_SPACE: &str = ") ";
89
90pub const AND_PAREN_WRAP: &str = ") AND (";
91pub const OR_PAREN_WRAP: &str = ") OR (";
92
93pub const INSERT_FROM_SELECT: &str = ") SELECT ";
94
95pub const LIMIT_ONE: &str = "1";
96
97pub const TRUE: &str = "1";
98pub const FALSE: &str = "0";