Hi @Vinyasa_Health, I'm sorry to hear about your frustration.
As you mentioned, Retool doesn't support OAuth queries in public apps. Your use case is possible with External Applications if patients are designated as external users within your organization (members of the External Users Permission Group). This way, the app wouldn’t need to be public and you’d be able to implement OAuth successfully.
It seems like you're looking for a workaround to have patients not be a part of your organization, paying only for therapists as external users. It should be no surprise that our documentation does not include how to go around our pricing model.
@Darren shared a workaround for something similar using a Workflow to store the token in a shared database. For your use case, you would need to trigger this workflow from the app, then run a query to get that token from the shared db. It may be worth a shot, but you'd have to be careful with the scope of that token.