SqlHydra

SqlHydra copied to clipboard

Add documentation and setup configuration on how to clone the repo, build the project, and run tests.

2

I'd like to pull down this project and open it up in vscode with the proper dependencies installed with documentation on how to build the project and run tests. For...

EverybodyKurts

Should be able to make a selected column from a leftJoined table optional by wrapping it with `Some`. For example: ```F# let! results = selectTask HydraReader.Read (Create openContext) { for...

JordanMarr

Conditional where's, orderBy's, and thenBy's

6

I saw [this issue](https://github.com/JordanMarr/SqlHydra/discussions/28) a while ago and thought I'd contribute. If you'd like a PR instead, I'd be happy to send one over. type SelectQueryBuilder with /// Sets the...

sydsutton

Add Support for tuple in where clauses

3

Thanks for the great library. Another thing I've found is probably missing support for tuple query generation in where clauses? ```fsharp selectTask HydraReader.Read ctx { for a in draftItemTable do...

Swoorup

SqlHydra.Cli doesn't map Sqlite longvarchar column types

5

When using SqlHydra.Cli against a Sqlite database, the F# types and readers do not include columns that are of type `longvarchar`. A mapping is missing in `SqlHydra.Cli/Sqlite/SqliteDataTypes.fs ` e.g. `"longvarchar",...

robmaw

Is it possible call `date_trunc` from PostgreSQL?

7

In SQL, I want to write something like ```sql SELECT date_trunc('day', fsvr."CompletedTimeStamp"), fsvr."FormSpecType", count(fsvr."FormSpecType") FROM dbo."FormStudioValuesResult" AS fsvr WHERE fsvr."TenantId" = '9003665c-a1c3-486e-90db-85f7a053ded8' group by 1, fsvr."FormSpecType"; ``` Is it possible...

MangelMaxime

System.InvalidOperationException: The input sequence has an insufficient number of elements.

3

Hi I am using a select statement getting less colunms than the actual type in the result. ```fs let sql = $""" SELECT g.SiteId, gm.GroupId,g.Title,g.Owner, g.OwnerIsUser,gm.MemberId, u.tp_Login, u.tp_Title, u.tp_Email FROM...

RicoSaupe

NoWarn 3391

3

I am trying out the selectTask example exactly as in the documentation on a net8.0 console application. I am getting a warning which i cannot figure out. Am I missing...

RicoSaupeBosch