Escaping = when querying files on s3 storage

[saptarshiguha]

Hello,

Firstly, thanks! And also firstly, thanks for making the developer ux(documentation, api) so seamless. I onboarded in one sleepy hour. As for my question

1. I am storing data on S3
2. I am using Postgres as the catalog

CREATE PERSISTENT SECRET IF NOT EXISTS dsipostgres (
    TYPE postgres,
    HOST '',
    PORT 1111,
    DATABASE 'my_harvest',
    USER 'byname',
    PASSWORD 'my password'
);

CREATE PERSISTENT SECRET IF NOT EXISTS s3_secretes (
    TYPE s3,
    KEY_ID '<KEY_ID>',
    SECRET 'username',
    PROVIDER config,
    ENDPOINT 'foo.moo.com',
    URL_STYLE 'path'
);

I attached to the DB

ATTACH 'ducklake:postgres:dbname= my_harvest'
    AS poem_harvest (META_SECRET 'dsipostgres', DATA_PATH 's3://a/my_harvest');

And I successfully wrote data using create table and insert into. Seamless. I also have partitions e.g. ALTER TABLE my_harvest.poem_projects SET PARTITIONED BY (project_type,grading_context_id);

Now I tried one query

select * from my_harvest.poem_projects where created_at>='2025-06-20'"

and error was

 HTTP Error: HTTP GET error on 'https://....my_harvest/main/poem_projects/project_type%3DFoo/grading_context_id%3DGTX/ducklake-01978903-4323-78ce-998d-3ed760b645b4.parquet' (HTTP 404)

But when I browse the s3 location I do see the file

s3 ls s3://a/my_harvest/main/poem_projects/project_type=Foo/grading_context_id=GTX/ducklake-01978903-4323-78ce-998d-3ed760b645b4.parquet 

And when I run the following query in duckdb it works

select * from 's3://a/my_harvest/main/poem_projects/project_type=Foo/grading_context_id=GTX/ducklake-01978903-4323-78ce-998d-3ed760b645b4.parquet'

Is duck lake replacing = with the escaped versions? (or is the error happening elsewhere)

thanks again

(some errors in copy/paste/and other information removal, but the observations made are correct)

[saptarshiguha]

Looks like I need to do

INSTALL httpfs;
LOAD httpfs;

Why do I need this for duck lake but when querying a parquet file it's not required?