I have a weird issue where I can't import from a postgres view that has 2 underscores in the name. If I remove one of the underscores, it works fine. Using the pipelinewise postgres tap.

Sounds like a tap issue, you could put an issue in here https://github.com/transferwise/pipelinewise-tap-postgres I've messed with a really early POC of a tap-postgres with the sdk here https://github.com/MeltanoLabs/tap-postgres you could give it a try as well 🤷 no gurantees