Explore uses of DuckDB to create a single column to iterate

[datejada]

What and Why

What is better, to iterate over the :raw DB table and get the row.column or to use SELECT to get a single column as result, but then pipe to DataFrame. This might improve this part of the code.

    name_to_id = Dict(
        row.name => i for
        (i, row) in enumerate(TulipaIO.get_table(Val(:raw), connection, "assets_data"))
    )

Possible Drawbacks

No response

Related Issues

No response