Not really. Your queries don't have to contain tenant Id if as part of your tenant context they have a connection string to their tenant DB.
I have recently been using row level security with a transaction middleware where I set the tenant ID.
Nice article regarding it - https://aws.amazon.com/blogs/database/multi-tenant-data-isol...
So, it works.
We're wanting to move off that architecture to something more future proof, but it's not our biggest pain point at this point in time.