Unsure if it's in other SQL ecosystems but I *love* the wildcard syntax BigQuery has - makes it (intentionally) super easy with our data taxonomy.
If you have a load of tables inside a dataset, you can query across all of those tables with e.g.:
```
select col1, col2 from `some_dataset.*` where ...
```
We have a dataset per "service" (CDN, load balancer etc.) so if you want to query across everything on that services, it's nice and simple.
@tdp_org I think the approach in most other SQL databases and better aligning to the standard, would be for that to be part of the predicate.
IE: select ... from dataset where service = x and ...
And partitioning taking care of where the data actually lives.
To me 'dataset.*' feels odd, since querying all tables in a schema makes no sense to me.
@intrbiz the closest thing I can think of for ClickHouse is support for hive-style partitioning where you can do
```
SELECT
source,
*
FROM file('chungus/transitous/2025-10-06/source=*/stops.txt')
SETTINGS use_hive_partitioning = 1
```
and source gets inferred from the directory structure
but the preferred way is to have a single schema as you suggest
@tdp_org