Although initially it seemed otherwise, your point on having a different interface to confusion between complete SQL compatibility v/s the subset being offered

Although initially it seemed otherwise, your point on having a different interface to confusion between complete SQL compatibility v/s the subset being offered makes a lot of sense. Also personally I would rather prefer an imperative language for tasks where efficiency is the primary concern compared to declarative SQL