The following known limitations apply to the HFQL SQL syntax. These limitations are not considered permanent or unsolvable, but were implemented for practical reasons. Please get in touch if you have use cases that they are restricting, or if you would like to help address them.
When using GROUP BY expressions, the query will fail if more than 10000 unique values are found to group by.
When using ORDER BY expressions, the query will fail if more than 10000 values are found to order by.
Expressions with WHERE clauses do not support parentheses or OR statements, only AND statements.
JOIN statements are not supported.
Comments are not currently supported