Update DuckDB version to the new major release 1.0

[pedrosalgadowork]

🚀 The feature

It would be a good time to upgrade the duckdb package version to the new major release 1.0, since it's the latest stable version from where most of the APIs should be final.

pandas-ai/pyproject.toml

Line 19 in f895e5f

duckdb = "<1"

Motivation, pitch

Having it locked to the <1 can be a block to someone who wants to use the new release.locked

Alternatives

No response

Additional context

No response