Foreign Data Wrappers-like API?

[penberg]

Postgres allows accessing other databases via its FDW API. For SQLite, there are things like

https://github.com/mergestat/dblite

and

https://github.com/frectonz/pglite-fusion

But perhaps Limbo can do something more native here?

[madejejej]

IMO Clickhouse nailed it with table functions

Examples:

SELECT * FROM
file('test.csv', 'CSV', 'column1 UInt32, column2 UInt32, column3 UInt32')
LIMIT 2;

INSERT INTO TABLE FUNCTION
file('test.tsv', 'TSV', 'column1 UInt32, column2 UInt32, column3 UInt32')
VALUES (1, 2, 3), (3, 2, 1), (1, 3, 2)

SELECT *
FROM s3(
   'https://datasets-documentation.s3.eu-west-3.amazonaws.com/aapl_stock.csv',
   'CSVWithNames'
)
LIMIT 5;

SELECT name FROM mysql(`mysql{1|2|3}:3306`, 'mysql_database', 'mysql_table', 'user', 'password');