Example of query interception to rewrite a fake table with predicates

[danthegoodman1]

I woul dlike to use fabduckdb to intercept queries to a non-existent table, including predicates, and replace them with a table function.

So a query like:

select *
from icedb
where year >= 2022
and year <= 2023

Could be intercepted in python, and rewritten to be:

select *
from icedb(start_year:=2022, end_year:=2023)

Or even at this extent, it could be rewritten even further to avoid the table macro and go right to something like:

select *
from read_parquet([...], hive_partitioning=1, filename=1)
where ...

Tracked for IceDB here: danthegoodman1/icedb#45

[danthegoodman1]

I see that subqueries and CTEs aren't currently supported, which will make it hard to fully implement this for IceDB querying