Is your feature request related to a problem? Please describe.

may I ask for some help converting this to a Athena/Presto view:
https://github.com/cloudquery/cloudquery/blob/main/plugins/source/aws/views/resources.sql

Describe the solution you'd like

convert this Postgres SQL to Athena/Presto SQL
https://github.com/cloudquery/cloudquery/blob/main/plugins/source/aws/views/resources.sql