What does observability mean? Can you translate this into a concrete question? As for flexibility, do you mean authentication or authorization? SSO can be don

What does observability mean? Can you translate this into a concrete question? As for flexibility, do you mean authentication or authorization? SSO can be done at the SQL server level (MSSQL has it and so does Postgres, don't know about others), but handling the SSO part in your app and using "set role" and passing a user ID for your row level security policies to use is easier to set up and more flexible. Clean separation between user and machine accounts can absolutely be done with MSSQL and Postgres.