Is there an easy way to decrement an existing column in a row? Not sure how to best do a basic counter.

Thanks, Gary. I guess what I don't understand well enough then is how or if I can use SQL with the auto API and JS sdk somehow or if I need to go another route.

You use the dashboard sql editor to do anything beyond basic stuff.

Got it, very cool. Looks like this is what I'm missing. Thanks! https://supabase.com/docs/guides/database/functions

There is some automated UI for postgres functions, but things like sequences you have to do those in sql and alter tables in sql. You can do simpler functions with the UI, but as they get more complex (especially with complex record(s) returns) you need to use SQL

To clarify, are you calling out the difference between the

SQL Editor

in the dashboard for the more complex and then the

Database -> Functions

being the simple?

Yes

Thanks again. 👍