The execution of SQL-inf on the Infer platform has a few limitations compared to other SQL variants and execution engines.
Over time these limitations will disappear as new iterations of the Infer platform are released.
- Infer only supports SQL-inf in SELECT statements
- Infer only supports naked SELECTs - not within CREATE statements
Compute limits are set on a per account basis depending on your plan.