duckdb_engine icon indicating copy to clipboard operation
duckdb_engine copied to clipboard
verified publisher icon Mause

[Bug]: Reflection on indices

Open raffaem opened this issue 6 months ago • 1 comments

What happened?

Just thought to open a issue to track the implementation of reflection on indices

DuckDB Engine Version

0.17.0

DuckDB Version

v1.3.0 71c5c07cdd

SQLAlchemy Version

No response

Relevant log output

Code of Conduct

  • [x] I agree to follow this project's Code of Conduct

raffaem avatar Jun 13 '25 07:06 raffaem

Hey, just wanted to add my 2 cents: I think it would be very important to have this feature. Right now Alembic is not very usable (at least when auto-generating migrations) because it doesn't properly infer types on indices.

Subsequent invocations of the autogenerate-upgrade workflow currently are not idempotent: they produce non-existent changes (e.g. JSON is reflected as String, DateTime as TIMESTAMP).

danielgafni avatar Nov 13 '25 22:11 danielgafni