Union is available with the SQL over HTTP endpoint https://xata.io/docs/sdk/sql/overview as well as with direct wire protocol access to Postgres-enabled (beta) databases https://xata.io/docs/postgres