SQL

To query tables using a subset of standard SQL, send the query payload through POST request to /api/sql endpoint. This is the only query interface that supports table joins.

SQL query frontend is the more flexible and powerful compared to REST and GraphQL. It is the only query frontend that supports table joins.

SQL frontend supports [""] operator for accessing struct fields and array element. For example struct_col["key1"]["key2"] or array_col[0].