[FEATURE] IN subquery list query optimization support

[jeffreyaven]

Feature Description
An extension of #329, but instead of a list of scalar values the values can be obtained from a subquery (executed first).

Example(s)

SELECT
function_name,
region,
runtime,
arn
FROM aws.lambda.function
WHERE region = 'us-east-1'
AND data__Identifier IN 
(SELECT function_name
FROM aws.lambda.functions
WHERE region IN ('us-east-1','us-east-2','us-west-1','us-west-2','ap-south-1','ap-northeast-3','ap-northeast-2','ap-southeast-1','ap-southeast-2','ap-northeast-1','ca-central-1','eu-central-1','eu-west-1','eu-west-2','eu-west-3','eu-north-1','sa-east-1'))