Skip to content

Allow DbType to do type conversions #1266

Open
@Jolanrensen

Description

@Jolanrensen

Currently, you can only specify how the JDBC types are mapped to a KType/ColumnSchema.
This must strictly follow the types of the specific implementation of the DataBase JDBC integration to prevent runtime errors, often resulting in very non-Kotlinlike types, such as java.sql.Date, DuckDBBlobResult, or org.duckdb.JsonNode.

Other DataFrame integrations aim to convert the types to something close to kotlin, such as KotlinX LocalDateTime.
Allowing to specify a conversion like this would also allow conversions like SomeJsonFormat -> ColumnGroup/FrameColumn on-the-fly #462 and java.sql.Array -> List<T>

Metadata

Metadata

Assignees

Labels

databasesJDBC related issuesenhancementNew feature or request

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions