Many of those choices to make it easier only work if you're willing to disallow a lot of SQL semantics.
Like, tradeoffs in consistency? No transactions? That requires not implementing some important bits of SQL.
Like, tradeoffs in consistency? No transactions? That requires not implementing some important bits of SQL.