aws glue/athena has the most absurd setup process. duckdb and clickhouse is “select * from s3(…)”
I'm not sure what do you mean by "absurd setup". In case of Athena you just use the iceberg type for a table as you create it and that's it. Under the hood AWS also uses Trino or Presto as far as I know.