relational-query

Typeful, Modular, Relational, algebraic query engine

http://khibino.github.io/haskell-relational-record/

Version on this page:0.12.2.2
LTS Haskell 23.19:0.12.3.1
Stackage Nightly 2025-04-30:0.12.3.1
Latest on Hackage:0.12.3.1

See all snapshots relational-query appears in

BSD-3-Clause licensed by Kei Hibino
Maintained by [email protected]
This version can be pinned in stack with:relational-query-0.12.2.2@sha256:6898c7ed9367b0542f119501cdc29f22489e467b330c122478ab496bf1a9bcf0,7486

Module documentation for 0.12.2.2

Used by 1 package in lts-15.3(full list with versions):
relational-schemas

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.2.2

  • bugfix. fix record width of fromMaybe.

0.12.2.1

  • fix changelog.

0.12.2.0

  • add configuration flags to fix problem of correlation. – Thanks for Yoshikuni Jujo
  • not import LiteralSQL instance for UTF-8 encoded ByteString by default.
  • not import LiteralSQL instance for ZonedTime and UTCTime corresponding TIMESTAMPTZ by default.
  • deprecations of some old APIs.

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

0.9.0.2

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

0.4.0.0

  • Extend derivedInsert.

0.3.0.0

  • Add generalized restrict.
  • Pass configuration to DELETE and UPDATE.

0.2.0.0

  • Update structure of query with placeholders.