These guys wrote the most popular Ruby on Rails multitenant gem and eventually moved away from it:

https://influitive.io/our-multi-tenancy-journey-with-postgre...

Some things were mistakes but others look like pretty fundamental flaws. Performance is a problem, database changes are a problem, and you aren't able to query across tenants.

I'm using this in practice and it has served me well for years.