This package contiains typeful relation structure and
relational-algebraic query building DSL which can
translate into SQL query.
Supported query features are below:
- Type safe query building
- Restriction, Join, Aggregation
- Modularized relations
- Typed placeholders
Changes
0.12.1.0
add LiteralSQL instances of word and integer types.
0.12.0.1
update missing of this changelog.
0.12.0.0
rename from ShowConstantTermsSQL to LiteralSQL.
drop #tuplePiM_N.
drop old compat modules for relational-query-0.9.x.
0.11.4.0
add xxxNoPH effect APIs of arrow-interface.
0.11.3.0
add some overloaded projection instances for tuple types.
add #primary overloaded projection instance.
0.11.2.0
add insertValueList API.
(re-)add xxxNoPH effect APIs.
prepare to rename derivedXxx to xxx.
deprecate typed* APIs with implicit defaultConfig.
0.11.1.0
add compatibility module Database.Relational.Query.TH for upgrading from 0.9.
0.11.0.0
same as 0.10.1.1. re-versioned for TH incompatibility against 0.10.0.
0.10.1.1
fix overloaded-labels instances for GHC 8.2.
0.10.1.0
define projections with overloaded-labels. – Thanks for Ryan Mulligan
add a portable sequence number operation.
0.10.0.0
switch namespace to Database.Relational
update interfaces about projection types.
divide and apply product-isomorphic interfaces.
0.9.5.0
export QuerySuffix and unsafe-query functions from Database.Relational.Query namespace for libraries.
0.9.4.1
fix version constraint.
0.9.4.0
add NULLS FIRST and NULLS LAST to ORDER BY clause.
0.9.3.0
add Show instance of Pi.
add pzero and ConstantTermsSQL instance of ().
add Category instance of Pi.
0.9.2.1
add tested-with 8.2.1.
0.9.2.0
Add derivedInsertValue definitions to arrow interface.
Apply chunked-insert to derivedInsertValue.
0.9.1.0
Fix of unsafeValueNull. ( https://github.com/khibino/haskell-relational-record/issues/55 )
0.9.0.2
Bugfix of case projected record. ( https://github.com/khibino/haskell-relational-record/issues/54 )
0.9.0.1
Use Haskell implementation test instead of flag test in .cabal
0.9.0.0
Add HRR instances of tuple types derived by generic programming.
Add generic instances of ShowConstantTermsSQL.
0.8.3.6
Bugfix of lazy instances of ShowConstantTermsSQL.
0.8.3.5
Deprecate some exported interfaces which are internal definitions.
0.8.3.4
Update this changelog
0.8.3.3
simpl-tick-factor work-around to avoid bug of GHC
0.8.3.2
Export Register interface type from Query module.
0.8.3.1
Refactor around sub-query and its builder.
Compatibility with dlist-0.5.
0.8.3.0
Add configuration to quote SQL string of table names.
0.8.2.3
Add tested-with meta-data.
0.8.2.2
Update for GHC 8.
0.8.2.1
Fix constraint of build-depends.
0.8.2.0
Add TIMESTAMPTZ literal of PostgreSQL.
0.8.1.0
Add schemaNameMode configuration.
0.8.0.5
Update tests along with deprecations.
0.8.0.4
Drop unused pragma.
0.8.0.3
Drop unreferenced overloading.
0.8.0.2
Update documentation.
0.8.0.1
Fix build-depends.
0.8.0.0
Drop unsafe Expr type.
Drop redundant type synonyms around DELETE and UPDATE.
Add Register monad to add build-able INSERT statement
Configurable relation template names.
0.7.1.0
Deprecate redundant type synonyms.
0.7.0.2
Prepare to drop Expr type and deprecate around it.
Fix boolean projection operator types.
0.7.0.1
Update this changelog.
0.7.0.0
Use TH quotations for deriving class symbols.
0.6.4.0
Fix around correlated sub-queries.
Update unit-test cases.
0.6.3.0
Add Int8 type as SQL constant int value. (e.g. MySQL)
0.6.2.0
Make InsertQuery type as PreparedNoFetch instance.
0.6.1.0
Add a configuration flag to pring verbose compile-time messages.
0.6.0.0
Increase type safety of interfaces.
Simplify interfaces arond unique query.
0.5.2.0
Add MonadTrans instance of QueryJoin.
Update links about Opaleye.
0.5.1.1
Update documentation.
0.5.1.0
Add the arrow combinator module and its unit-test cases.
0.5.0.3
Update unit-test cases.
Add the fixity of over operator.
Avoid an `a future Prelude name’ warning.
0.5.0.2
Switch libraries to use from test-suites not to depend on Cabal library.
0.5.0.1
Add this ChangeLog file.
0.5.0.0
Prevent window function context expression from using normal SQL expressions.
Generalize the result types of aggregate and window functions.
Allow to embed a integer literal in SQL from Haskell Int type.
Add SQL LIKE operators.
Drop old deprecated functions. (fromMaybe’, dense_rank, …)