Numeric columns are converted to varchar upon import from PostgresQL

[nvennin]

Describe the bug
When importing a view from a postgres database (hosted with supabase), columns that are fixed precision digits (numeric) are imported as varchar. I would expect them to be imported as duckdb numeric type.

To Reproduce
Steps to reproduce the behavior:

1. Go to Sources
2. Create a model that pulls from a postgres database, containing numeric columns (see example below)

# Source YAML
# Reference documentation: https://docs.rilldata.com/reference/project-files/sources

type: source

connector: "postgres"
database_url: "postgresql://[email protected]:5432/postgres"
sql: "select line_amount_eur::real as value_real, line_amount_eur::numeric as value_numeric from analysis.sales_order_lines sol limit 10;"

3. See that the column casted as numeric in the sql is imported as varchar.

Expected behavior
I would expect numeric columns to be imported as numeric.

Screenshots
See above

Desktop (please complete the following information): not relevant

Rill version: 0.49.1

Additional context
n/a

[mindspank]

Do you get the same error on latest version of Rill?

::numeric should default to a 3 scale and 18 decimals. Is your data perhaps wider then that? Figured that duckdb might be smart and trying to auto cast to fit your data

[nvennin]

Still the same. It seems that, somehow, rill's importer coerces numeric columns to varchar.