PR to add schema parsing to some table-value functions. This allows you to give schema for a

read_csv

or

read_json

using SQL!

SELECT * FROM read_json('/path/to/data.json', schema := {
    'x': 'int',
    'y': 'string',
    'z': 'bool',
});

-- ditto for read_csv and read_parquet