The Pipe Syntax is currently supported in GoogleSQL, an SQL dialect used across several of Google's SQL products, both publicly and internally, including BigQuery, Spanner, F1, Bigtable, Dremel ...

FROM table1, table2 WHERE table1.keyfield=table2.keyfield When you execute a statement like this, SQL creates a new table—the results recordset—based on the contents of table1 and table2.

The CONNECT statement establishes a connection with the DBMS. You establish a connection to send DBMS-specific SQL statements to the DBMS or to retrieve DBMS data. The connection remains in effect ...