I think it will be straightforward to expose time_bucket in pg_duckdb. Feel free to open an issue for the feature.