Wren Core return SQL is invalid for BigQuery

[grieve54706]

Description

The statement

SELECT ABS(o_orderkey) FROM my_catalog.my_schema.orders

Be transformed to

SELECT abs(orders.o_orderkey) FROM (SELECT orders.o_orderkey FROM (SELECT tpch_tiny.orders.o_orderkey AS o_orderkey FROM tpch_tiny.orders) AS orders) AS orders

Error message

Unrecognized name: tpch_tiny at [1:75]

It can't execute on BigQuery because the tpch_tiny.orders.o_orderkey should be orders.o_orderkey. Can not be with schema.

SELECT ABS(orders.o_orderkey) FROM (SELECT orders.o_orderkey FROM (SELECT orders.o_orderkey AS o_orderkey FROM tpch_tiny.orders) AS orders) AS orders;

[grieve54706]

But it's worked for Postgres.

[goldmedal]

It will be fixed by apache/datafusion#13241