v2.1.0
SqlHydra.Cli
- The TOML configuration
[filters]
section now has a newrestrictions
setting that allows passing restrictions (filters) toGetSchema
. This gives you the ability to pre-filter the queried schema. For example, you can pre-filter to only pull tables in a certain schema. (These filters are not as configurable as the existinginclude
andexclude
glob patterns, but they have been added to help pre-filter extremely large databases to reduce generation times. Unless you are experiencing performance issues, you should use the globinclude
andexclude
post-filters instead.)
See TOML configuration docs here: https://github.com/JordanMarr/SqlHydra/wiki/TOML-Configuration#schema-restrictions - TOML configuration glob filters are now applied to filter tables before columns are collected / processed for each table. This is a small efficiency change.
SqlHydra.Query
- Boolean unary expressions are now supported (without having to explicitly assign
= true
or= false
)
✅ This is now valid and doesn't require an extra parameter!
select {
for o in Sales.SalesOrderHeader do
where o.OnlineOrderFlag
}
✅ This is now valid and doesn't require an extra parameter!
select {
for o in Sales.SalesOrderHeader do
where (not o.OnlineOrderFlag)
}