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]
.