You are right andneo the platform as it stands now is suitable for building CRUD applications since what we currently offer is to setup you objects fields, user permissions and data APIs through configuration.
We plan to implement data streams and workflows with Lambda style functions that will cover even the most complex application demands in the near future.
Supabase is a nice service with a lot of functionality but requires that you know advanced features of postgres (rls policies etc ..) to properly setup your data security.
With supabase you are bound to what features can be developed on top of postgres which is a double edge sword in my opinion. in addition, we believe that our simple sql syntax over API is much more intuitive and easy to learn in contrast to postgrest syntax.