search

google / zetasql

ZetaSQL - Analyzer Framework for SQL
Apache License 2.0
2.28k stars 214 forks source link

Support EXTERNAL_QUERY tvf #145

Open pgrivachev opened 1 year ago

pgrivachev commented 1 year ago

Hi!

Is it possible to declare EXTERNAL_QUERY tvf in ZetaSQL catalog? It is required to declare a return type that is a relation with known column names and types. In the EXTERNAL_QUERY we don't have this information and I couldn't find any way to declare tvf that returns table with unknown columns.

lukehalasy-anchorage commented 1 year ago

Related issue: https://github.com/google/zetasql/issues/90