flowscope-core 0.7.0

Core SQL lineage analysis engine
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83

//! Alias visibility and scoping rules per dialect.
//!
//! Generated from scoping_rules.toml

use crate::Dialect;

impl Dialect {
    /// Whether SELECT aliases can be referenced in GROUP BY.
    pub const fn alias_in_group_by(&self) -> bool {
        match self {
            Dialect::Bigquery => true,
            Dialect::Clickhouse => true,
            Dialect::Databricks => true,
            Dialect::Duckdb => true,
            Dialect::Hive => true,
            Dialect::Mssql => false,
            Dialect::Mysql => true,
            Dialect::Oracle => false,
            Dialect::Postgres => false,
            Dialect::Redshift => true,
            Dialect::Snowflake => false,
            Dialect::Sqlite => true,
            _ => false, // Default: strict (Postgres-like)
        }
    }

    /// Whether SELECT aliases can be referenced in HAVING.
    pub const fn alias_in_having(&self) -> bool {
        match self {
            Dialect::Bigquery => true,
            Dialect::Clickhouse => true,
            Dialect::Databricks => true,
            Dialect::Duckdb => true,
            Dialect::Hive => true,
            Dialect::Mssql => false,
            Dialect::Mysql => true,
            Dialect::Oracle => false,
            Dialect::Postgres => false,
            Dialect::Redshift => true,
            Dialect::Snowflake => false,
            Dialect::Sqlite => true,
            _ => false,
        }
    }

    /// Whether SELECT aliases can be referenced in ORDER BY.
    pub const fn alias_in_order_by(&self) -> bool {
        match self {
            Dialect::Bigquery => true,
            Dialect::Clickhouse => true,
            Dialect::Databricks => true,
            Dialect::Duckdb => true,
            Dialect::Hive => true,
            Dialect::Mssql => true,
            Dialect::Mysql => true,
            Dialect::Oracle => true,
            Dialect::Postgres => true,
            Dialect::Redshift => true,
            Dialect::Snowflake => true,
            Dialect::Sqlite => true,
            _ => true, // ORDER BY alias is widely supported
        }
    }

    /// Whether lateral column aliases are supported (referencing earlier SELECT items).
    pub const fn lateral_column_alias(&self) -> bool {
        match self {
            Dialect::Bigquery => true,
            Dialect::Clickhouse => true,
            Dialect::Databricks => true,
            Dialect::Duckdb => true,
            Dialect::Hive => true,
            Dialect::Mssql => false,
            Dialect::Mysql => false,
            Dialect::Oracle => false,
            Dialect::Postgres => false,
            Dialect::Redshift => false,
            Dialect::Snowflake => true,
            Dialect::Sqlite => false,
            _ => false,
        }
    }
}