fsprojects / SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
https://fsprojects.github.io/SQLProvider
Other
564 stars 144 forks source link

(sqlite) add support for column that has no type showed in `pragma table_info` #787

Closed Tangent-90 closed 1 year ago

Tangent-90 commented 1 year ago

Proposed Changes

Currently when connecting to a sqlite database, if a view contains columns that have no type showed in pragma table_info (such as string concat by ||, a CASE-WHEN expression, etc), the SQLProvider will ignore them. This PR tries to make them visible to SQLProvider.

Types of changes

What types of changes does your code introduce to SQLProvider? Put an x in the boxes that apply

Checklist

Put an x in the boxes that apply. You can also fill these out after creating the PR. If you're unsure about any of them, don't hesitate to ask. We're here to help! This is simply a reminder of what we are going to look for before merging your code.

Further comments

If this is a relatively large or complex change, kick off the discussion by explaining why you chose the solution you did and what alternatives you considered, etc...

Thorium commented 1 year ago

Thanks!

Thorium commented 1 year ago

Released in 1.3.7