BlazingDB is a new database technology, so we are not SQL complete. We focus on making sure every statement we build runs lightning fast, and that frankly takes time.
Below you can see all the statements we do support.
Have a strong need for a particular SQL statement? Please let us know in our support page.