I am thinking of an application where multiple users can interactive with the workbench BUT the workbench performs its actions against the database as one user. That way, it could consolidate the connections into a single one

In other words, a database server around Sqlite? That seems like the kind of thing that should exist!