Support filter_schema setting

[ShahBinoy]

I am trying to perform ELT with meltano elt command against Postgres Tap (MeltanoLabs)
But I am getting error

psycopg2.errors.InsufficientPrivilege: permission denied for schema pdr_ops

Since the remote database is a third party Database, we do not have access to pdr_ops schema. Why is it trying to access pdr_ops schema. I only need to check against pdr schema

How can I limit my operations to only one schema pdr and not face this permissions error ?

meltano.yaml

  - name: pdr
    inherit_from: tap-postgres
    variant: meltanolabs
    pip_url: git+https://github.com/MeltanoLabs/tap-postgres.git
    capabilities: 
    - state
    select:
    - pdr-mv_participant_all.participant_id
    - pdr-mv_participant_all.id
    - pdr-mv_participant_all.modified
    metadata:
      pdr-mv_participant_all:
        replication-method: INCREMENTAL
        replication-key: modified
        view-key-properties: [id]

[visch]

https://github.com/meltano/sdk/blob/main/singer_sdk/connectors/sql.py#L371 is a good place to look I think we could add a config here. Maybe there's better options here though.

[visch]

meltano/sdk#1234 @edgarrmondragon pointing to as another issue we may have to add a feature for as well. We'll want to add a test here on the database as well which will take a bit more time!