The deficiencies of SQL to use it as frontend databases:

1. Standard SQL doesn’t support nesting
2. SQL syntax is verbose and non-uniform.
3. SQL’s scalar expression language is weird and limited
4. SQL doesn't have good tools for metaprogramming and changing the shape of a query at runtime