Add options to specify whether or not to add PathKeys for `Get` KeyColumns, and possibly for "optional' list columns

[johnsmyth]

• We should ALWAYS specify PathKeys for required 'KeyColumns' on 'List' calls, and we should force this path. This is required in order to join these tables at all (must be a nested loop join, with a filtered scan)
• We should DEFAULT to NOT specifying PathKeys for Get KeyColumns when a table has a List with no required KeyColumns. This will result in a path where both tables are scanned and then joined/merged by postgres after they are returned by the plugin. For most cases, this is likely more efficient (even more soe with caching enabled)
• We may want to add an ability for the plugin to specify pathkeys for Get (or maybe on other "optional" list/get columns, TBD) if the List call is thought to be very expensive compared to a few Get calls.

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 90 days with no activity.