Debug SQLAlchemy 2.0 .scalars().all() use

[xlorepdarkhelm]

Fixing the db.session.execute(stmt).scalars().all() problem.

This was part of the move to SQLAlchemy 2.0, and it could be very problematic. scalars() gets a single value from a row, while all() gets all the rows and puts them into a list. So this makes a list of single values. Which is fine, if and only if we only want a single value from the row. But if you want all the columns that are loaded (like from a invited user model), this breaks a lot of things, and has unknown results.

We need to go through all uses of this pattern in the API code and verify - are we wanting just a single column's data to be returned, or multiple columns of data returned. If multiple columns of data, then we need to remove the .scalars() part of that code.

We might need to verify all other uses of .scalars() or .scalar() beyond those that use .all() too.

[ccostino]

Noting here that we still have an open PR for SQLAlchemy updates: #1417

We should go through this more closely given this insight and make adjustments before merging it in.