the current SQL engine is very limited and i heard that it is one of the oldest part of the codebase. it would be great to get all the basic sql features like arithmetic, IN, multiple JOIN, SpacetimeType support and so on.

Requested by @xDovos via the SpacetimeDB site.