INNER JOIN can join only two tables We will support joining multiple tables in the future,
Multiple aggregation functions when using GROUP BY does not work We will support it in the next release.
Casting cannot be done in JOIN clause We are aware of this but we do not plan to add it soon. It is possible to support it but it is difficult to implement in our solution.
Aggregations without GROUP BY do not work with NULL values We will fix this in the next release.
The order of table columns after importing a database from a CSV file may be different from CSV file This would require too much work to fix and we do not consider it as an important issue, so we do not plan to fix this. However, if you consider it as a major issue, let us know and we will reconsider.
The function IS NULL does not work together with other conditions in WHERE clause (e.g. colA = 0 OR colA IS NULL) We will fix this in the next release.
All data has to be in the memory (RAM), if data cannot fit in there, it will fail We will implement loading from disk on demand and release it in June 2020.