Changelog for esqueleto-3.4.3.0
3.4.3.0
- @parsonsmatt
- @parsonsmatt
- #255
- Fix a bug where a composite primary key in a
groupBy
clause would break.
- Fix a bug where a composite primary key in a
- #255
3.4.2.1
- @parsonsmatt
- #245
- Support
persistent-2.13
- Support
- #245
3.4.2.0
- @parsonsmatt
- #243
- Support
persistent-2.12
- Support
- #243
3.4.1.1
- @MaxGabriel
- #240
- Improve recommend hlint to avoid doing
x = NULL
SQL queries
- Improve recommend hlint to avoid doing
- #240
3.4.1.0
- @arthurxavierx
- #238
- Fix non-exhaustive patterns in
unsafeSqlAggregateFunction
- Fix non-exhaustive patterns in
- #238
- @Vlix
- #232
- Export the
ValidOnClauseValue
type family
- Export the
- #232
3.4.0.1
- @arthurxavierx
- #221
- Deprecate
ToAliasT
andToAliasReferenceT
- Deprecate
- #221
- @parsonsmatt
- #226
- Support
persistent-2.11
- Support
- #226
- @belevy
- #225
- Simplify
ToFromT
extracting the overlapping and type error instances - Make
ToFromT
and associated type family ofToFrom
- Simplify
- #225
3.4.0.0
- @belevy, @charukiewicz
- #215
- Added support for common table expressions (
with
,withRecursive
) - Added support for lateral JOINs with updated example (Example #6)
- Deprecated
SelectQuery
, removing the neccessity to tagSqlQuery
values - Deprecated use of data constructors for SQL set operations (replaced with functions)
- Refactored module structure to fix haddock build (fixes build from
3.3.4.0
)
- Added support for common table expressions (
- #215
3.3.4.1
- @maxgabriel
- #214
- Add suggested hlint rules for proper
isNothing
usage
- Add suggested hlint rules for proper
- #214
3.3.4.0
- @parsonsmatt
- #205
-
More documentation on the
Experimental
module -
Database.Esqueleto.Experimental
now reexportsDatabase.Esqueleto
, so the new "approved" import syntax is less verbose. Before, you'd write:import Database.Esqueleto hiding (from, on) import Database.Esqueleto.Experimental
Now you can merely write:
import Database.Esqueleto.Experimental
Users will get 'redundant import' warnings if they followed the original syntax, the solution is evident from the error message provided.
-
- #205
3.3.3.3
- @belevy
- #191 - Bugfix rollup: Fix issue with extra characters in generated SQL; Fix ToAliasReference for already referenced values; Fix Alias/Reference for Maybe Entity
- @maxgabriel
- #203 Document
isNothing
- #203 Document
- @sestrella
- #198 - Allow PostgreSQL aggregate functions to take a filter clause
3.3.3.2
- @maxgabriel
- #190 Further document and test
ToBaseId
- #190 Further document and test
3.3.3.1
- @belevy
- #189 - Fix bug in function calls with aliased values introduced by SubQuery joins.
3.3.3.0
- @belevy
- #172 - Introduce new experimental module for joins, set operations (eg UNION), and safer queries from outer joins.
3.3.2
- @belevy
- #177 Fix natural key handling in (^.)
3.3.1.1
- @parsonsmatt
- #170 Add documentation to
groupBy
to explain tuple nesting.
- #170 Add documentation to
3.3.1
- @charukiewicz, @belevy, @joemalin95
- #167: Exposed functions that were added in
3.3.0
- #167: Exposed functions that were added in
3.3.0
- @charukiewicz, @belevy, @joemalin95
- #166: Add several common SQL string functions:
upper_
,trim_
,ltrim_
,rtrim_
,length_
,left_
,right_
- #166: Add several common SQL string functions:
3.2.3
- @hdgarrood
- #163: Allow
unsafeSqlFunction
to take up to 10 arguments without needing to nest tuples.
- #163: Allow
3.2.2
- @parsonsmatt
- #161: Fix an issue where nested joins didn't get the right on clause.
3.2.1
- @parsonsmatt
- #159: Add an instance of
UnsafeSqlFunction ()
for 0-argument SQL functions.
- #159: Add an instance of
3.2.0
- @parsonsmatt
- #153: Deprecate
sub_select
and introducesubSelect
,subSelectMaybe
, andsubSelectUnsafe
.
- #153: Deprecate
- @parsonsmatt
- #156: Remove the
restriction that
on
clauses must appear in reverse order to the joining tables.
- #156: Remove the
restriction that
3.1.3
- @JoseD92
- #155: Added
insertSelectWithConflict
postgres function.
- #155: Added
3.1.2
- @tippenein
- #149: Added
associateJoin
query helpers.
- #149: Added
3.1.1
-
@JoseD92
- #149: Added
upsert
support.
- #149: Added
-
@parsonsmatt
- #133: Added
renderQueryToText
and related functions.
- #133: Added
3.1.0
- @Vlix
- #128: Added
Database.Esqueleto.PostgreSQL.JSON
module with JSON operators andJSONB
data type.
- #128: Added
- @ibarrae
- #127: Added
between
and support for composite keys inunsafeSqlBinOp
.
- #127: Added
3.0.0
- @parsonsmatt
- #122: Support
persistent-2.10.0
. This is a breaking change due to the removal of deprecated exports from thepersistent
library. - #113: Remove the
esqueleto
type class. To migrate here, useSqlExpr
,SqlQuery
, andSqlBackend
instead of using the polymorphicEsqueleto sqlExpr sqlQuery sqlBackend => ...
types.
- #122: Support
2.7.0
- @parsonsmatt
- #117: Removed
sqlQQ
andexecuteQQ
functions from export, fixing doc build and building withpersistent
>= 2.9
- #117: Removed
2.6.1
- @ChrisCoffey
- #114: Fix Haddock by working around an upstream bug.
2.6.0
- @bitemyapp
- Reorganized dependencies, decided to break compatibility for Conduit 1.3, Persistent 2.8, and
unliftio
. - Moved tests for
random()
into database-specific test suites. - Deprecated Language
random_
, split it into database-specific modules.
- Reorganized dependencies, decided to break compatibility for Conduit 1.3, Persistent 2.8, and
- @parsonsmatt
- Added support for
PersistQueryRead
/PersistQueryWrite
, enabling type-safe differentation of read and write capabilities.
- Added support for
- @sestrella
- Added support for
arrayAggDistinct
andarrayRemove
.
- Added support for
- @mheinzel
- Fixed JOIN syntax in the documentation https://github.com/bitemyapp/esqueleto/pull/60
- @illmade
- Added instructions for running database specific tests
- @FintanH
- Removed CPP from the test suite, split the database-specific tests into their own respective modules.
- Added support for PostgreSQL's
now()
- Added a comprehensive examples project to make practical application of Esqueleto easier.
- @EdwardBetts
- Fixed a spelling error