relational-query

Typeful, Modular, Relational, algebraic query engine

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

Version on this page:0.9.4.1
LTS Haskell 22.14:0.12.3.1
Stackage Nightly 2024-03-28: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.9.4.1@sha256:108662b8c129fbc0a5324e4fc273f4b874b88eee09862e140918978ec466515e,6336

Module documentation for 0.9.4.1

  • Database
    • Database.Relational
      • Database.Relational.Query
        • Database.Relational.Query.Arrow
        • Database.Relational.Query.BaseTH
        • Database.Relational.Query.Component
        • Database.Relational.Query.Constraint
        • Database.Relational.Query.Context
        • Database.Relational.Query.Derives
        • Database.Relational.Query.Effect
        • Database.Relational.Query.Monad
          • Database.Relational.Query.Monad.Aggregate
          • Database.Relational.Query.Monad.Assign
          • Database.Relational.Query.Monad.BaseType
          • Database.Relational.Query.Monad.Class
          • Database.Relational.Query.Monad.Register
          • Database.Relational.Query.Monad.Restrict
          • Database.Relational.Query.Monad.Simple
          • Database.Relational.Query.Monad.Trans
            • Database.Relational.Query.Monad.Trans.Aggregating
            • Database.Relational.Query.Monad.Trans.Assigning
            • Database.Relational.Query.Monad.Trans.Config
            • Database.Relational.Query.Monad.Trans.Join
            • Database.Relational.Query.Monad.Trans.Ordering
            • Database.Relational.Query.Monad.Trans.Restricting
          • Database.Relational.Query.Monad.Type
          • Database.Relational.Query.Monad.Unique
        • Database.Relational.Query.Pi
          • Database.Relational.Query.Pi.Unsafe
        • Database.Relational.Query.Projectable
        • Database.Relational.Query.ProjectableClass
        • Database.Relational.Query.ProjectableExtended
        • Database.Relational.Query.Projection
        • Database.Relational.Query.Pure
        • Database.Relational.Query.Relation
        • Database.Relational.Query.SQL
        • Database.Relational.Query.Scalar
        • Database.Relational.Query.Sub
        • Database.Relational.Query.TH
        • Database.Relational.Query.Table
        • Database.Relational.Query.TupleInstances
        • Database.Relational.Query.Type

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