"select distinct arn ..." (and similar) should be "select distinct on (arn) arn ..."

[e-gineer]

Many queries in this mod use distinct to prevent duplicates. For example:

steampipe-mod-aws-compliance/query/vpc/vpc_flow_logs_enabled.sql

Lines 1 to 3 in 56d5f70

	select
	-- Required columns
	distinct arn as resource,

Distinct checks all elements in the tuple (row), as opposed to ensuring the specific arn or name (common ones) is actually distinct.

So, queries like this:

select
  distinct arn as resource,

should actually be:

select distinct on (arn)
  arn,

A an example to see the difference, please try these two queries:

select distinct region, name from aws_s3_bucket order by region, name;

select distinct on (region) region, name from aws_s3_bucket order by region, name;

[github-actions]

'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]

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

[github-actions]

'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.'