v2.5.0

SqlHydra.Query v2.5.0

• In a select query, specifying a table or tables using the select keyword now explicitly selects all the columns in the table record; previously, it would issue a select tbl.* query. It is now recommended to always explicitly select a table. (If you do not explicitly select, it will generate a select tbl.* style query which will be less performant.)

Ex:

❌ This will issue a SELECT * query which will result in a table scan which will result in slightly worse performance.

    let! results = 
        selectTask' openContext {
            for p in Person.Person do
            take 10
        }

✅ This will explicity select all columns in the Person table, which will result in slightly better performance.

    let! results = 
        selectTask' openContext {
            for p in Person.Person do
            take 10
            select p
        }

SqlHydra.Cli v2.5.0

• The generated HydraReader now filters out any columns that do not exist in the selected table record(s). (This fixes a bug that could happen when a column was added to a table and the types were not regenerated.

NOTE: You must upgrade both SqlHydra.Query and SqlHydra.Cli at the same time to v2.5.x.