They are similar in that you have some data stored somewhere, and you can query it as though it was data stored inside a 'conventional' database that has it's own storage that it manages itself.
But whereas Presto/Trino/Bigquery/etc are server-based where queries execute on a cluster of compute nodes, duckdb is something you run locally, in-process.
But whereas Presto/Trino/Bigquery/etc are server-based where queries execute on a cluster of compute nodes, duckdb is something you run locally, in-process.