ZetaSQL can specify the syntax for exporting and importing data.
EXPORT DATA
[OPTIONS (key=value, ...)]
AS query;
The EXPORT DATA
statement writes out a query result. You can use this
statement to write a result to a file or stream the result into another system.
Documentation is pending for this feature.