feat: Add Max Records Limit

[visch]

Feature scope

Taps (catalog, state, stream maps, tests, etc.)

Description

Sometimes we don't want to query more than x number of records for every query. MeltanoLabs/tap-postgres#24 (comment) had an issue where they were getting timeouts to their postgres connection when trying to pull their table over. I assume this is because the table is very large and the initial sync is too big to complete in the timeout window. This can be useful for folks, although it shouldn't be something folks jump to right away to use to fix issues as it could cause other issues (especially if #18 gets implemented)

Example implementation MeltanoLabs/tap-postgres#393

[stale]

This has been marked as stale because it is unassigned, and has not had recent activity. It will be closed after 21 days if no further activity occurs. If this should never go stale, please add the evergreen label, or request that it be added.