f5      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEF G H I J K L MNOPQRSTUVWXYZ[\]^_`abc d e f g h i jklm n o p q r s t u v w x y z { | } ~        !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~                              !!!!!!!!!!!!!!!!!!!!! ! ! ! ! !!!!!!!!!!!!!!!!!"" "!"""#"$"%"&"'"(")"*"+","-"."/"0"1"2"3"4"5"6"7"8"9":";"<"=">"?"@"A"B"C"D"E"F"G"H"I"J"K"L"M"N"O"P"Q"R"S"T"U"V"W"X"Y"Z"["\"]"^"_"`"a"b"c"d#e#f#g#h#i#j#k#l$m$n$o$p$q$r$s$t$u$v$w$x$y$z${$|$}$~$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$%%%%%%%%%%%%%%%%%%%%%02013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;*Constraint which represents scalar degree. instance templates.&2014-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownSafe9;!String wrap type for SQL strings. from . to .Row String of SQL values.Place holder row String of SQL.List String of SQL.List String of SQL.'2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownSafeUntyped typed table typeName string of table in SQLWidth of tableColumn name strings in SQLColumn name strings in SQL,Column name string in SQL specified by index Column indexColumn name String in SQL2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone6:QR aI is implicit rule to derive function to convert from haskell record type a into constant SQL terms.Generic programming ( ehttps://downloads.haskell.org/~ghc/latest/docs/html/users_guide/glasgow_exts.html#generic-programming*) with default signature is available for , class, so you can make instance like below:  {-# LANGUAGE DeriveGeneric #-} import GHC.Generics (Generic) -- data Foo = Foo { ... } deriving Generic instance ShowConstantTermsSQL Foo *Weaken applicative functor on projections.  Method like . Weaken functor on projections.  Method like . CSpecify tuple like record constructors which are allowed to define  .The constructor which has type r.Same as  . other than using inferred record constructor.          4 42013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone:ATProjection path from type r0 into type r16. This type also indicate key object which type is r1 for record type r0.'Projection path primary structure type.&Unsafely untype key to expand indexes.MUnsafely cast width proof object of record. Result record must be same width.Projectable fmap of  type.Projectable ap of  type.Get record width proof object.Get record width.Compose projection path.Compose projection path.  phantom functor is -ed.Compose projection path.  phantom functors are join -ed like >=>.$Unsafely project untyped value list.*Unsafely define projection path from type r0 into type r1.*Unsafely define projection path from type r0 into type r1. Use inferred .*Unsafely define projection path from type r0 into type r1. *Unsafely define projection path from type r0 into type r1. Use inferred .!Compose projection path 6 which has record result type using applicative style." Compose seed of projection path  which has record result type.Index of flat SQL value listResult projection pathIndex of flat SQL value listResult projection pathIndexes of flat SQL value listResult projection path Indexes of flat SQL value listResult projection path!"    !"8882013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone#Identity projection path.$!Projection path for fst of tuple.%!Projection path for snd of tuple.#$Projection path of fst.%Projection path of snd. #$% #$%#$%2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;Constant integral SQL terms.Escape $ for constant SQL string expression.From % into constant SQL string expression.&Constant SQL terms of # type. Width inference is required.'Constant SQL terms of T. This generates ***NOT STANDARD*** SQL of TIMESTAMPTZ literal with UTC timezone.(Constant SQL terms of B. This generates ***NOT STANDARD*** SQL of TIMESTAMPTZ literal.)Constant SQL terms of .*Constant SQL terms of .+Constant SQL terms of .,Constant SQL terms of (. Caution for floating-point error rate.-Constant SQL terms of (. Caution for floating-point error rate..Constant SQL terms of ./Constant SQL terms of .0Constant SQL terms of .1Constant SQL terms of .2Constant SQL terms of .3Constant SQL terms of .4Constant SQL terms of .5Constant SQL terms of U. Use this carefully, because this is architecture dependent size of integer type.6Constant SQL terms of .7Constant SQL terms of .8Constant SQL terms of .9Constant SQL terms of .&'()*+,-./0123456789&'()*+,-./01234567892013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone :Inference rule of < existence.<Phantom typed table type= Untype table.>Name string of table in SQL?)Not qualified name string of table in SQL@Width of tableAColumn name strings in SQLB,Column name string in SQL specified by indexCCast phantom type into  type.D+Unsafely generate phantom typed table type. :;<=>?@AB Column indexColumn name String in SQLCD :;<=>?@ABCD <=>?@ABDC:; :;<=>?@ABCD(2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownSafeETypeful aggregate element.Type for group-by treeType for grouping setType for group key.Type for group-by term Single term aggregation element.Key of aggregation power set.Single grouping set.Rollup aggregation element.Cube aggregation element.Grouping sets aggregation.Empty aggregation.0Compose GROUP BY clause from AggregateElem list.9Compose PARTITION BY clause from AggregateColumnRef list.Extract typed projection from E.Extract untyped term from E.5Unsafely bind typed-projection and untyped-term into E.E     E     E     )2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownSafeF#Type tag for aggregatings power setG'Type tag for aggregatings GROUPING SETSH$Type tag for normal aggregatings setI%Type tag for window function buildingJType tag for exists predicateKType tag for aggregated queryL(Type tag for flat (not-aggregated) queryFGHIJKLFGHIJKLFGHIJKL*2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneMConfiguration type.U2Configuration for quotation of identifiers of SQL.X'Schema name qualify mode in SQL string.Y)Schema qualified table name in SQL stringZ&Not qualified table name in SQL string[$Unit of product is supported or not.^^/ type to customize names of expanded templates.bDefault configuration.MNOPQRSTUVWXYZ[\]^_`abMNOPQRSTUVWXYZ[\]^_`abMNOPQRSTUVWXYZ[\]^_`ab 2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneIc. type to require query generate configuration.dRun c to expand with configurationeLift to c.fRead configuration.cdefcdefcedfcdef+2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownSafe Assignment pairValue SQL String of assignmentColumn SQL String of assignmentType for order-by termType for order-by columnj)Order direction. Ascendant or Descendant.#Result record duplication attribute%Compose duplication attribute string.*Compose ORDER BY clause from OrderingTermsCompose SET clause from [].Compose VALUES clause from [].jkl jkl  jkl ,2015-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone234#mType for restriction of query.n=Phantom typed projection. Projected into Haskell record type t.!Discard projection value type o'Untyped projection. Forgot record type.p2Projection structure unit with single column width",used in immediate value or unsafe operations# normalized sub-query reference T n with Int index$scalar sub-query% nth column of case clause& case clause' when clausesqType for join product of query.r*Product noe with join restriction builder.(+Product tree with join restriction builder.)#Product tree with join restriction.*.Product node. node attribute and product tree.+KProduct tree type. Product tree is constructed by left node and right node.snode attribute for product.vQualified query.wQualifier type.ySub-query type,Set binary operators- Set operators. Get qualifier/ Unqualify.0 Add qualifier1Get node attribute.2Get tree from node.3 Width of o.4Unsafely type projection value.5 Width of n.6Unsafely generate n from SQL string list.7Unsafely generate n from scalar sub-query.8.Search case operator correnponding SQL search CASE . Like, 1CASE WHEN p0 THEN a WHEN p1 THEN b ... ELSE c END9.Simple case operator correnponding SQL simple CASE . Like, 1CASE x WHEN v THEN a WHEN w THEN b ... ELSE c END9mn:!op"#$%&;<'=qr()*>+?@ABstuvCwxyDEFG,H-IJK./0123456!SQL string list specifies columnsResult n7L Error tagEach when clausesElse result projection Result clause8Each when clausesElse result projectionResult projection9Projection value to matchEach when clausesElse result projectionResult projection5mn!op$"#%&;<'=qr()*>+?@sutvCwxyDGFE,H-IJK./0123456789!mn:!op"#$%&;<'=qr()*>+?@ABstuvCwxyDEFG,H-IJK./01234567L89-2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneM&Push new tree into product right term.N+Push new leaf node into product right term.O1Add restriction into top product of product tree.P6Add restriction into top product of product tree node.M Current treeNew tree to push into right Result nodeN Current treeNew leaf to push into right Result nodeOProduct to restrictRestriction to addResult productP)Target node which has product to restrictRestriction to add Result nodeNPMNOP.2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneQJoinContext type for QueryJoin.RInitial Q.SUpdate product of Q.T6Finalize context to extract accumulated query product.QUVRSTQRSTQUVRST/2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneIW&Monad type to qualify SQL table forms.X8Run qualify monad with initial state to get only result.Y*Generated new qualifier on internal state.ZLift to W[Get qualifyed table form query.W\XYZ[Query to qualifyResult with updated stateWXZ[W\XYZ[ 2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownSafeFGHIJKLLKJIHGF 2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone zy from <.{Unsafely generate flat y from untyped components.|Unsafely generate aggregated y from untyped components.}Union binary operator on y~Except binary operator on yIntersect binary operator on y Width of y.]SQL to query table.^*Generate normalized column SQL from table._Normalized column SQL`-SQL string for nested-query and toplevel-SQL.SQL string for nested-qeury.SQL StringSQL for toplevel-SQL.SQL string for toplevel-SQL.aAlias string from qualifierbBinary operator to qualify.c9Qualified expression from qualifier and projection index.dFrom v" SQL string into qualified formed  like (SELECT ...) AS T n Width of v SubQUery.Get column SQL string of y..Make untyped projection from joined sub-query.e1index result of each when clause and else clause.f1index result of each when clause and else clause.g(Convert from ProjectionUnit into column.hGet column SQL string of o.)Get column SQL string list of projection.Unsafely get SQL term from  Proejction.i6Show product tree of query into SQL. StringSQL result.jShows join product of query.kCompose SQL String from m.Compose WHERE clause from m.Compose HAVING clause from m.'lmzTyped < metadataResult y{|n}~]^_o`sub-query SQL and top-level SQLpqrabcdefghSource n Column indexResult SQL stringSource nResult SQL string listijkmnopqrsutvwxyz{|}~yz{|}~wxvnpoqsturm'lmz{|n}~]^_o`pqrabcdefghijk 2015-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone *Relation type with place-holder parameter p and query result type r.&Thin monad type for untyped structure.Run - monad with initial state to get only result.Get qualifyed table form query.Read configuration.AUnsafely type qualified subquery into record typed relation type.&Sub-query Qualify monad from relation.9Simplify placeholder type applying left identity element.:Simplify placeholder type applying right identity element.Generate SQL string from  with configuration.SQL string from .Dump internal structure tree.st st 2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone:Projection type for row list.Unsafely get SQL term from  Proejction.)Get column SQL string list of projection. Width of n. Unsafely get untyped projection.Unsafely generate n# from qualified (joined) sub-query.Unsafely generate n from scalar sub-query.Unsafely generate unqualified n from <.Unsafely generate n from SQL expression strings.uUnsafely trace projection path.&Trace projection path to get narrower n.&Trace projection path to get narrower n. From  type to  type.&Trace projection path to get narrower n. From  type to * type. Leaf type of projection path is .Composite nested  on projection phantom type. Cast into  on projection phantom type.Unsafely cast context type tag.$Unsafely lift to aggregated context.Unsafely down to flat context.>Unsafely get SQL string expression of not null key projection.Projectable fmap of n type.Projectable ap of n type.Make row list projection from n list.Make row list projection from y.IMap projection show operatoions and concatinate to single SQL expression.Compose record type n using applicative style.Compose seed of record type n.vwSource nResult SQL string listuSource nProjection path Narrower nSource n.  typeProjection path Narrower n.  type resultSource n.  typeProjection path.  type leaf Narrower n.  type resultxynnvwuxy2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone Type for query suffix wordsExpand query suffix words%Generate prefix string of update SQL.`Generate update SQL by specified key and table. Columns name list of table are also required.`Generate update SQL by specified key and table. Columns name list of table are also required.,Generate update SQL specified by single key.%Generate prefix string of insert SQL.z"Generate records chunk insert SQL.0Generate size measured records chunk insert SQL.Generate insert SQL.IGenerate all column delete SQL by specified table. Untyped table version.2Generate all column delete SQL by specified table.  Table nameColumn name list to updateKey column name list Result SQL Table nameColumn name listKey column indexes Result SQLTable metadata Key columns Result SQLzRecords count to insertColumns selector to insertTable metadata Result SQLColumns selector to insertTable metadata#Chunk size threshold (column count)%Result SQL and records count of chunkColumns selector to insertTable metadata Result SQLTable metadata Result SQL z2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<=  Constraint  inference interface.Infer constraint key.-Constraint Key proof object. Constraint type c, record type r and columns type ct.,Index of key which specifies constraint key.{ Width of key.Unsafely generate constraint ( proof object using specified key index.Get table constraint | proof object from constraint .1Get projection path proof object from constraint .}6Unsafe. Make constraint key to add column phantom type~*Map from table constraint into constraint .Derive  constraint  from  constraint Infered  constraint . Record type r has unique key which type is ct derived from primay key. {-Key indexes which specify this constraint key"Result constraint key proof object}~   {}~2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneEMNOQPTSRUVWXYZ[\]^_`abjkl^_`a[\]XYZUVWMNOPQRSTbEjkl2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone*9;Make template for   instance.;Make template of ProductConstructor instance of tuple type.Make template of  instance of tuple type.3Make templates of projection paths for tuple types.2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;T'2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;U)Zipping except for identity element laws.Interface to control  of phantom type in projections."Cast projection phantom type into .Compose nested  phantom type on projection.BPlaceholder parameter type which has real parameter type arguemnt p.$Binary operator type for SQL String.+Interface to get SQL term from projections.=Unsafely generate SQL expression term from projection object.(Interface to project SQL terms unsafely.+Unsafely project from SQL expression terms.!Unsafely Project single SQL term.8Unsafely Project single SQL string. String interface of .)Polymorphic projection of SQL null value.JGenerate polymorphic projection of SQL constant values from Haskell value.)Polymorphic proejction of SQL true value.*Polymorphic proejction of SQL false value.:Polymorphic proejction of SQL set value from Haskell list.WUnsafely generate SQL expression string from projection object. String interface of .9Unsafely make projection unary operator from SQL keyword.EUnsafely make projection binary operator from string binary operator.MUnsafely make compare projection binary operator from string binary operator.NUnsafely make numrical projection binary operator from string binary operator.#Compare operator corresponding SQL = .#Compare operator corresponding SQL < .#Compare operator corresponding SQL <= . #Compare operator corresponding SQL > . #Compare operator corresponding SQL >= . #Compare operator corresponding SQL <> . #Logical operator corresponding SQL AND . #Logical operator corresponding SQL OR .#Logical operator corresponding SQL NOT .#Logical operator corresponding SQL EXISTS .'Concatinate operator corresponding SQL || .'Concatinate operator corresponding SQL || . Maybe type version.*String-compare operator corresponding SQL LIKE .*String-compare operator corresponding SQL LIKE .*String-compare operator corresponding SQL LIKE .*String-compare operator corresponding SQL LIKE . Maybe type version.IUnsafely make number projection binary operator from SQL operator string."Number operator corresponding SQL + ."Number operator corresponding SQL - .'Number operator corresponding SQL /// ."Number operator corresponding SQL * .-Number negate uni-operator corresponding SQL -.!Number fromIntegral uni-operator.:Unsafely show number into string-like type in projections."Number operator corresponding SQL + ."Number operator corresponding SQL - .'Number operator corresponding SQL /// . "Number operator corresponding SQL * .!-Number negate uni-operator corresponding SQL -."!Number fromIntegral uni-operator.#:Unsafely show number into string-like type in projections.$.Search case operator correnponding SQL search CASE . Like, 1CASE WHEN p0 THEN a WHEN p1 THEN b ... ELSE c END%Same as $, but you can write like  whenlist %  elseclause.&Null default version of $.'.Simple case operator correnponding SQL simple CASE . Like, 1CASE x WHEN v THEN a WHEN w THEN b ... ELSE c END(Uncurry version of ', and you can write like ... (  elseclause.)Null default version of '.*"Binary operator corresponding SQL IN .+Operator corresponding SQL IS NULL% , and extended against record types.,Operator corresponding SQL NOT (... IS NULL)$ , and extended against record type.-/Operator from maybe type using record extended isNull..RANK() term./ DENSE_RANK() term.0 ROW_NUMBER() term.1PERCENT_RANK() term.2 CUME_DIST() term.3.Unsafely add placeholder parameter to queries.4"Unsafely get placeholder parameter5No placeholder semantics)Unsafely cast placeholder parameter type.6;Provide scoped placeholder and return its parameter object.7LProvide scoped placeholder and return its parameter object. Monadic version.8Zipping projections.9Binary operator the same as 8.:Compose record type  using applicative style.;Compose seed of record type .<LZipping except for identity element laws against placeholder parameter type.=Control phantom  type in projection type n.>Control phantom  type in placeholder parameters.?Unsafely get SQL term from  Proejction.BUnsafely make n from SQL terms.CUnsafely make n from SQL terms.DUnsafely make n from SQL terms.aSource projection objectResult SQL expression string.      !"#$Each when clausesElse result projectionResult projection%Each when clausesElse result projectionResult projection&Each when clausesResult projection'Projection value to matchEach when clausesElse result projectionResult projection(4Projection value to match and each when clauses listElse result projectionResult projection)Projection value to matchEach when clausesResult projection*+,-./0123456789:;<=>?@ABCDJ      !"#$%&'()*+,-./0123456789J34675     * +,-!"#%($&')./01289Z      !"#$%&'()*+,-./0123456789:;<=>?@ABCD444 4 4 4 3 25544446677667 7*4912013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<=E(Window specification building interface.FAdd  PARTITION BY term into context.G,Aggregated query building interface extends L.HAdd GROUP BY1 term into context and get aggregated projection.J'Lift interface from base qualify monad.KLift from qualify monad q into L* m. Qualify monad qualifies table form SubQuery.LQuery building interface.MSpecify duplication.NAdd restriction to last join.O+Join sub-query with place-holder parameter p. query result is not .P+Join sub-query with place-holder parameter p. Query result is .QRestrict context interfaceR Add restriction to this context.S'Specify ALL attribute to query context.T,Specify DISTINCT attribute to query context.U6Add restriction to last join. Projection type version.V-Add restriction to this not aggregated query.WMAdd restriction to this aggregated query. Aggregated Projection type version.EFGHIJKLMNOPQRSTUVWXEFGHIJKLOPMNQRSTUVWJKQRLMNOPGHIEFSTUVW EFGHIJKLMNOPQRSTUVWX2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=IY/Context monad type to build partition keys set.Z.Context monad type to build grouping set list.[/Context monad type to build grouping power set.\0Context monad type to build single grouping set.])Context type building partition keys set.^&Context type building power group set._)Context type building grouping sets list.`'Context type building one grouping set.a0Type to accumulate aggregating context. Type ac is aggregating-context type like aggregating key set building, aggregating key sets set building and partition key set building. Type at is aggregating term type.bLift to a.cRun a to get terms list.d3Specify key of single grouping set from Projection.e#Specify key of single grouping set.f)Finalize and specify single grouping set.g)Specify key of rollup and cube power set.h0Finalize grouping power set as rollup power set.i.Finalize grouping power set as cube power set.jFinalize grouping set list.kPartition clause instancelAggregated query instance.m Aggregated L.n Aggregated J.o Aggregated Q.YZ[\]^_`abcdefghijklmnoYZ[\]^_`abcdefghijab`_^]c\[ZYdefghijYZ[\]^_`abcdefghijklmno2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=ItTarget of assignment.u.Type to accumulate assigning context. Type r is table record type.vLift to uwAdd an assignment.xAdd and assginment.yRun u to get  AssignmentszJ with assigning.{Q with assigning. tuvwxyz{tuvwxyuvwxty tuvwxyz{x42015-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone6Target register monad type used from insert statement.Run InsertStatement.2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<=I(Ordering term projection type interface.-Type to accumulate ordering context. Type c* is ordering term projection context type.Lift to .Add ordering terms.Add ordering terms.Add ascendant ordering term.Add descendant ordering term.Run  to get  OrderingTermsn is ordering term.E with ordering.G with ordering.L with ordering.J with ordering.Q with ordering.Order directionOrdering terms to addResult context with orderingOrdering terms to addOrder directionResult context with orderingOrdering terms to addResult context with orderingOrdering terms to addResult context with ordering2014-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=I/Type to accumulate query restrictions. Type cT is context tag of restriction building like Flat (where) or Aggregated (having).Lift to Add whole query restriction.Run  to get m Resticted G instance. Restricted L instance. Restricted J instance.Q instance. 2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=<RestrictedStatement type synonym. Projection record type r must be the same as  type parameter r.IRestrict only monad type used from update statement and delete statement.Run  to get m.2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=AssignStatement type synonym. Specifying assignments and restrictions like update statement. Projection record type must be the same as Target type parameter r.HTarget update monad type used from update statement and merge statement.Run .2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone.InsertTarget type with place-holder parameter p and projection record type r..UpdateTarget type with place-holder parameter p and projection record type r.-Restriction type with place-holder parameter p and projection record type r. Finalize Restrict monad and generate . Finalize Restrict monad and generate  with place-holder parameter pSQL WHERE clause  string from . Finalize Target monad and generate . Finalize Target monad and generate  with place-holder parameter p.Lift  to  . Update target columns are all.Lift  to 7. Update target columns are all. With placefolder type p. Finalize Restrict monad and generate  . Update target columns are all. Finalize Restrict monad and generate 7. Update target columns are all. With placefolder type p. SQL SET clause and WHERE clause  string from  Finalize  monad and generate . Finalize Target monad and generate  with place-holder parameter p.SQL INSERT statement  string from Show where clause.2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<=I) type to accumulate join product context.Lift to %Unsafely update join product context."Add last join product restriction.(Unsafely join sub-query with this query.#Basic monadic join operation using L.Run  to get qJoinable query instance. Attribute maybe or justy to joinResult joined context and y result projection. 2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone.OrderedQuery monad type with placeholder type p!. Projection must be the same as  context type parameter c.PCore query monad type used from flat(not-aggregated) query and aggregated query.Extract  computation.2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<=-Partition monad type for partition-by clause.Aggregated query type.  p r ==  ( p, n K r).Aggregated query monad type.Run  to get SQL with  computation.Run  to get y with  computation.?Operator to make window function result projection using built  monad. Restricted Q instance.  to runResult SQL string with  computation to runResult y with  computation 82013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=$Simple (not-aggregated) query type.  SimpleQuery' p r ==  ( p, n r).)Simple (not-aggregated) query monad type.%Lift from qualified table forms into .Run  to get SQL string with Qualify computation.Run  to get y with Qualify computation. to runResult SQL string with Qualify computation SimpleQuery' to runResult y with Qualify computation2014-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=IUnique query monad type./Unsafely join sub-query with this unique query.Run  SimpleQuery to get y with Qualify computation.Attribute maybe or justy to joinResult joined context and y result projection. to runResult y with Qualify computation 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<=3Interface to run recursively identity element laws.Interface to compose phantom  nested type.8Unsafely make aggregation uni-operator from SQL keyword.Aggregation function COUNT.Aggregation function SUM.Aggregation function SUM.Aggregation function AVG.Aggregation function AVG.Aggregation function MAX.Aggregation function MAX.Aggregation function MIN.Aggregation function MIN.Aggregation function EVERY.Aggregation function ANY.Aggregation function SOME.3Get narrower projection along with projection path.6Get narrower projection along with projection path  phantom functor is -ed.pGet narrower projection along with projection path and project into result projection type. Source record * phantom functor and projection path leaf  functor are join-ed.YGet narrower projection with flatten leaf phantom Maybe types along with projection path.YGet narrower projection with flatten leaf phantom Maybe types along with projection path. Specialize  for  type.>Base case definition to run recursively identity element laws.Run right identity element law.Run left identity element law.Not  type is not processed.Compose ! type in projection phantom type.Source projectionProjection pathNarrower projected objectSource n.  typeProjection pathNarrower projected object.  type resultSource n.  phantom typeProjection path.  type leafNarrower projected object.  phantom type resultSource n.  phantom typeProjection path Narrower n . Flatten  phantom typeSource n.  phantom typeProjection path&Narrower flatten and projected object.8888!2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone:-/Unique relation type to compose scalar queries.zRestriction predicate function type for direct style join operator, used on predicates of direct join style as follows. # do xy <- query $ relX  relY  F [ x y -> ... ] -- this lambda form has JoinRestriction type ... Simple  from <.Infered .Interface to derive < type object.$Join sub-query. Query result is not . Join sub-query. Query result is . The combinations of  and  express inner joins, left outer joins, right outer joins, and full outer joins. Here is an example of a right outer join:  outerJoin = relation $ do e <- queryMaybe employee d <- query department on $ e ?! E.deptId' .=. just (d ! D.deptId') return $ (,) |$| e |*| d List sub-query, for IN and EXIST with place-holder parameter p.List sub-query, for IN and EXIST. Finalize  monad and generate  with place-holder parameter p. Finalize  monad and generate . Finalize  monad and geneate  with place-holder parameter p. Finalize  monad and geneate .9Basic direct join operation with place-holder parameters./Direct inner join with place-holder parameters.4Direct left outer join with place-holder parameters.5Direct right outer join with place-holder parameters.4Direct full outer join with place-holder parameters.Basic direct join operation.Direct inner join.Direct left outer join.Direct right outer join.Direct full outer join. (Apply restriction for direct join style. Union of two relations. %Union of two relations. Not distinct. Subtraction of two relations. +Subtraction of two relations. Not distinct.Intersection of two relations.,Intersection of two relations. Not distinct.4Union of two relations with place-holder parameters.BUnion of two relations with place-holder parameters. Not distinct.:Subtraction of two relations with place-holder parameters.HSubtraction of two relations with place-holder parameters. Not distinct.;Intersection of two relations with place-holder parameters.IIntersection of two relations with place-holder parameters. Not distinct.!Unsafely specify unique relation.Discard unique attribute.#Basic monadic join operation using L.2Join unique sub-query with place-holder parameter p.2Join unique sub-query with place-holder parameter p. Query result is . Finalize  monad and generate . Aggregated .-Scalar sub-query with place-holder parameter p.Scalar sub-query.4Left query to joinRight query to joinJoin restrictionsResult joined relationLeft query to joinRight query to joinJoin restrictionsResult joined relationLeft query to joinRight query to joinJoin restrictionsResult joined relationLeft query to joinRight query to joinJoin restrictionsResult joined relationLeft query to joinRight query to joinJoin restrictionsResult joined relationLeft query to joinRight query to joinJoin restrictionsResult joined relationLeft query to joinRight query to joinJoin restrictionsResult joined relationLeft query to joinRight query to joinJoin restrictionsResult joined relation     *     *     3     88888888 8 7 7 7 788777788"2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone3zUntype interface for typed no-result type statments with single type parameter which represents place-holder parameter p. (Delete type with place-holder parameter p.#InsertQuery type.&"Insert type to insert record type a.*(Update type with place-holder parameter p.-Update type with key type p and update record type a. Columns to update are record columns other than key columns, So place-holder parameter type is the same as record type a.1'Query type with place-holder parameter p and query result type a.4Unsafely make typed 1 from SQL string.5From  into untyped SQL query string.6From  into typed 1 with suffix SQL words.7From  into typed 1.8Unsafely make typed - from SQL string.9 Make typed - from < and key columns selector .: Make typed -( object using derived info specified by  type.;Unsafely make typed * from SQL string.<$Make untyped update SQL string from < and .= Make typed * from M, < and .> Make typed * using b, < and .? Make typed * from M, derived table and @ Make typed * from b, derived table and A Make typed * from < and !. Update target is all column.BDirectly make typed * from < and Restrict/ monad context. Update target is all column.CDirectly make typed * from < and Restrict/ monad context. Update target is all column.DStatement to use chunked insertESize to use chunked insertFUnsafely make typed &+ from single insert and chunked insert SQL.GUnsafely make typed & from single insert SQL.H Make typed & from < and columns selector  with configuration parameter.I Make typed & from < and columns selector .JTable type inferred &.K Make typed & from M, < and monadic builded  object.L Make typed & from < and monadic builded  object.M Make typed & from M$, derived table and monadic builded  object.N Make typed & from b$, derived table and monadic builded  object.OUnsafely make typed # from SQL string.P+Make untyped insert select SQL string from <,  and .Q Make typed # from columns selector <,  and  with configuration parameter.R Make typed # from columns selector <,  and .STable type inferred #.TUnsafely make typed   from SQL string.U$Make untyped delete SQL string from < and .V Make typed   from M, < and .W Make typed   from < and .X Make typed   from M, derived table and RestrictContextY Make typed   from b, derived table and RestrictContext^Show delete SQL string_Show insert SQL string.`Show insert SQL string.aShow update SQL stringbShow update SQL stringcShow query SQL stringH !"#$%&'()*+,-./01234Query SQL to type Typed result56789:;<=>?@ABRestrict monad contextCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abc< !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXY<1234675-./089:*+,;=>?@ABC<&'()DEFGHIJKLMN#$%OQRSP !"TVWXYU9 !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abc#2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone:d$Query restricted with specified key.e+Query restricted with specified unique key.f,Query restricted with specified primary key.g+Query restricted with inferred primary key.hConvert from Haskell type r into SQL value q" list expected by update form likeUPDATE  tableN SET c0 = ?, c1 = ?, ..., cn = ? WHERE key0 = ? AND key1 = ? AND key2 = ? ... using derived  RecordToSql proof object.iTyped - using specified constraint key.jTyped - using inferred primary key.k inferred from table.d-Unique key proof object which record type is a and key type is p. to add restriction.Result restricted e-Unique key proof object which record type is a and key type is p. to add restriction.Result restricted f.Primary key proof object which record type is a and key type is p. to add restriction.Result restricted g to add restriction.Result restricted hi< to updateKey with constraint c, record type r and columns type p Result typed Updatej< to update Result typed Updatek-Unique key proof object which record type is a and key type is p.Unique key value to specify.Result restricted defghijkdefgijhkdefghijk02013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNones #$%:;<EFGHIJKLMNOQPTSRUVWXYZ[\]^_`abjklny      !"#$%&'()*+,-./0123456789EFGHIJLOPQRSTUVWdefghijwx      !"#$%&'()*+,-./01235679:<=>?@ABCDEFHIJKLMNPQRSUVWXYdefghijk$2015-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone:I:lArrow type corresponding to 12mArrow type corresponding to 13nArrow type corresponding to uoArrow type corresponding to pArrow type corresponding to qArrow type corresponding to [rArrow type corresponding to ZsArrow type corresponding to \tArrow type corresponding to uArrow type corresponding to vArrow type corresponding to wArrow to build queries.xSame as S. Arrow version.ySame as T. Arrow version.zSame as J. Arrow version. The result arrow is not injected by local projections.{Same as N. Arrow version. The result arrow is not injected by any local projections.|Same as ON. Arrow version. The result arrow is not injected by any local projections.}Same as PN. Arrow version. The result arrow is not injected by any local projections.~Same as U. Arrow version. The result arrow is designed to be injected by local projections.Same as U. Arrow version. The result arrow is designed to be injected by local projections.Same as  to pass this result to ^ operator. Arrow version. The result arrow is designed to be injected by local projections.Same as  to pass this result to ^ operator. Arrow version. The result arrow is designed to be injected by local projections.Same as G. Arrow version. Useful for no reference cases to local projections.Same as G. Arrow version. Useful for no reference cases to local projections.Same as X. Arrow version. The result arrow is designed to be injected by any local projection.Same as X. Arrow version. The result arrow is designed to be injected by any local projection.Same as G. Arrow version. Useful for no reference cases to local projections.Same as G. Arrow version. Useful for no reference cases to local projections.Same as J. Arrow version. The result arrow is not injected by local projections.Same as J. Arrow version. The result arrow is not injected by local projections.Same as Uf. Arrow version. The result arrow is designed to be injected by local conditional flat-projections.Same as Vf. Arrow version. The result arrow is designed to be injected by local conditional flat-projections.Same as Wl. Arrow version. The result arrow is designed to be injected by local conditional aggregated-projections.Same as HZ. Arrow version. The result arrow is designed to be injected by local flat-projections.Same as 7j. Arrow version. The result arrow is designed to be injected by locally built arrow using placeholders.Same as C. Finalize query-building arrow instead of query-building monad.Same as C. Finalize query-building arrow instead of query-building monad.Same as C. Finalize query-building arrow instead of query-building monad.Same as C. Finalize query-building arrow instead of query-building monad.Same as C. Finalize query-building arrow instead of query-building monad.Same as I4. This arrow is designed to be injected by local E.Same as dE. This arrow is designed to be injected by local flat-projections.Same as e4. This arrow is designed to be injected by local  AggregteKey.Same as f<. This arrow is designed to be injected by locally built  AggregtingSet arrow.Same as gE. This arrow is designed to be injected by local flat-projections.Same as h. Finalize locally built q.Same as i. Finalize locally built q.Same as j. Finalize locally built r.Same as F. The result arrow is designed to be injected by local projections.Same as F. The result arrow is designed to be injected by local projections.Same as F. The result arrow is designed to be injected by local projections.Same as FF. The result arrow is designed to be injected by local projections.Same as 8. Make window function result projection using built o arrow.Make tN into arrow which is designed to be injected by local projection assignees.Same as ? . Make *4 from assigning statement arrow using configuration.Same as @ . Make * from assigning statement arrow.Same as X . Make *3 from restrict statement arrow using configuration.Same as Y . Make * from restrict statement arrow.Blmnopqrstuvwxyz{|}~ #$%:;<EFGHIJKLMNOQPTSRUVWXYZ[\]^_`abjklny      !"#$%&'()*+,-./012345689EGJLQRwx      !"#$%&'()*+,-./01235679:<=>ABCDEFHIJKLMNPQRSUVWdefghijklmnopqrstuvwxyz{|}~:xyz{|}~wvutsrqponmlAlmnopqrstuvwxyz{|}~8%2013-2017 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=FT&Rule template to infer constraint key.#Rule template to infer primary key.#Rule template to infer primary key.$Rule template to infer not-null key.$Rule template to infer not-null key.Column projection path  template.Column projection path  and constraint key template.Column projection path  templates.SMake column projection path and constraint key templates using default naming rule.)Rule template to infer table derivations.4Template to define inferred entries from table type.< and  templates.Make TableDerivationH variable expression template from table name using default naming rule.Make <H variable expression template from table name using default naming rule.Make J variable expression template from table name using specified naming rule.Make template for record ProductConstructor& instance using specified naming rule.LMake templates about table and column metadatas using specified naming rule.RMake templates about table, column and haskell record using specified naming rule.Template of derived primary 1.Template of derived primary Update.'SQL templates derived from primary key.ASQL templates derived from primary key using default naming rule. All templates about primary key.!All templates about not-null key.>Generate all templtes about table using specified naming rule.Unsafely inlining SQL string 1 in compile type.8Extract param type and result type from defined RelationInlining composed 1 in compile type.nGenerate all templates against defined record like type constructor other than depending on sql-value type.!Constraint type Record typeKey typeIndexes specifies keyResult  declaration Record typeKey typeIndexes specifies key"Result constraint key declarationsconfiguration parameters Schema name Table name Column typePrimary key index&Declarations of primary constraint key Record type Column indexResult ColumnConstraint declarationconfiguration parameters Schema name Table nameNotNull key index&Declaration of not-null constraint key Record type Column declaration variable name0Column index expression in record (begin with 0) Column type"Column projection path declaration.May Constraint type and constraint object name Record type Column declaration variable name0Column index expression in record (begin with 0) Column type"Column projection path declarationRecord type nameColumn info list#Column projection path declarationsRecord type nameColumn info list#Column projection path declarationsTable declaration variable name"Relation declaration variable name*Insert statement declaration variable name/InsertQuery statement declaration variable name Record typeTable and Relation declarationTable declaration variable name"Relation declaration variable name*Insert statement declaration variable name/InsertQuery statement declaration variable name Record type'Table name in SQL ex. FOO_SCHEMA.table0 Column namesTable and Relation declarationTable name stringResult var ExpTable name stringResult var Exp2Configuration which has naming rules of templatesSchema name stringTable name stringResult var Exp$Configuration to generate query with Schema name Table name*Column names and types and constraint typeResult declarations$Configuration to generate query with Schema name Table nameColumn names and typesRecord derivingsResult declarations#Variable name of result declarationParameter type of 1Record type of 1 expressionResult 1 declaration#Variable name of result declarationParameter type of UpdateRecord type of Update< expressionResult Update declaration9Variable name of select query definition from primary key=Variable name of update statement definition from primary keyPrimary key type Record typeRelation expressionTable expressionResult declarationsTable name of DatabasePrimary key type Record typeRelation expressionTable expressionResult declarations Schema nameTable name stringType of primary keyIndexes specifies primary keyResult declarations$Configuration to generate query withSchema name string of DatabaseTable name string of DatabaseColumn names and typesderivings for Record typePrimary key indexNot null key indexResult declarationsQuery parameter typeQuery result typeSQL string query to inlineVariable name for inlined queryResult declarations%Variable name which has Relation type7Extracted param type and result type from Relation type"Top-level variable name which has  typeObject which has  typeConfiguration to generate SQLsuffix SQL words(Variable name to define as inlined queryResult declarationsType constructor nameResult declaration!4564574589:;&<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuOvwxy(z){)|)})~)))**********************  +++,,,,,,,,,,,,, O    v O S M N       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~23                              !!!y!!!!!!!! !!!"!#!$!%!&!'!(!)!*!+!!,!!-!!.!/!0!1!2!3!4!5!6!7!8!9!:!;!<"=">"?"?"@"A"A"B"C"C"D"E"F"F"G"H"H"I"J"K"K"L"M"N"O"P"Q"R"S"T"U"V"W"X"Y"Z"["\"]"^"_"`"a"b"c"d"e"f"g"h"i"j"k"l"m"n"o"p"q"r"s"t"u"v"w"x"y"z"{"|#}#~######$2$3$$$$$$$$$$$~$$$$z${$$$$$$$<$;$$$7$8$$$$s$b$ $$"$!$9$t$$$$$$$$$$$q$$$X$Y$q$r$$%%%%%%%%%%%%%%%%%%%%%&&&&&&'''''' '4Kr(((((((((((((((((z(((((((((** ++++++++ + + + + ,,,,,,,,,,,,,,,,,,, ,!,",#,$,O,R,,%,&,,,',(,),*,,r,,,+,,,,-,.,/-0-1-2-3.4.5.6.7.4.8/9/:/;///9 < = > ? @ P A B C D E F G H I J K L M N O P  Q R S T  UVO45WXYZ[\]^_!`abcdefghijklmnopqrstuvwx y!!z!{!6!|!}!~!!!""$$$$$$$$%%%%%%%%%%%%/relational-query-0.9.0.2-89icyZsFKuW81cprnsRZcq$Database.Relational.Query.Constraint Database.Relational.Query.Scalar*Database.Relational.Query.ProjectableClass#Database.Relational.Query.Pi.UnsafeDatabase.Relational.Query.PiDatabase.Relational.Query.PureDatabase.Relational.Query.Table#Database.Relational.Query.Component!Database.Relational.Query.Context,Database.Relational.Query.Monad.Trans.ConfigDatabase.Relational.Query.Sub(Database.Relational.Query.Monad.BaseType$Database.Relational.Query.ProjectionDatabase.Relational.Query.SQL Database.Relational.Query.BaseTH(Database.Relational.Query.TupleInstances%Database.Relational.Query.Projectable%Database.Relational.Query.Monad.Class1Database.Relational.Query.Monad.Trans.Aggregating/Database.Relational.Query.Monad.Trans.Assigning(Database.Relational.Query.Monad.Register.Database.Relational.Query.Monad.Trans.Ordering1Database.Relational.Query.Monad.Trans.Restricting(Database.Relational.Query.Monad.Restrict&Database.Relational.Query.Monad.Assign Database.Relational.Query.Effect*Database.Relational.Query.Monad.Trans.Join$Database.Relational.Query.Monad.Type)Database.Relational.Query.Monad.Aggregate&Database.Relational.Query.Monad.Simple&Database.Relational.Query.Monad.Unique-Database.Relational.Query.ProjectableExtended"Database.Relational.Query.RelationDatabase.Relational.Query.Type!Database.Relational.Query.DerivesDatabase.Relational.Query.ArrowDatabase.Relational.Query.TH&Database.Relational.Query.Internal.SQL/Database.Relational.Query.Internal.UntypedTable.Database.Relational.Query.Internal.GroupingSQL.Database.Relational.Query.Internal.ContextType)Database.Relational.Query.Internal.Config*Database.Relational.Query.Internal.BaseSQL&Database.Relational.Query.Internal.Sub*Database.Relational.Query.Internal.Product/Database.Relational.Query.Monad.Trans.JoinState-Database.Relational.Query.Monad.Trans.QualifyDatabase.Relational.QueryMonadicRestrictedStatementAssignStatement1persistable-record-0.5.0.1-D0Mzm6qRgxA45MSbuadEFuDatabase.Record.KeyConstraintUniqueNotNullPrimary ScalarDegreedefineScalarDegree$fScalarDegreeMaybe StringSQLShowConstantTermsSQLshowConstantTermsSQL'ProjectableApplicative|*|ProjectableFunctor|$|ProductConstructorproductConstructoripfmapshowConstantTermsSQL$fGShowConstantTermsSQLK1$fGShowConstantTermsSQLM1$fGShowConstantTermsSQL:*:$fGShowConstantTermsSQLU1PiunsafeExpandIndexespfmappapwidth<.>pidefinePidefineDirectPi'defineDirectPi$fProjectableApplicativePi$fProjectableFunctorPiid'fst'snd'$fShowConstantTermsSQLMaybe$fShowConstantTermsSQLUTCTime$fShowConstantTermsSQLZonedTime$fShowConstantTermsSQLLocalTime$fShowConstantTermsSQLTimeOfDay$fShowConstantTermsSQLDay$fShowConstantTermsSQLDouble$fShowConstantTermsSQLFloat$fShowConstantTermsSQLBool$fShowConstantTermsSQLChar$fShowConstantTermsSQLText$fShowConstantTermsSQLText0 $fShowConstantTermsSQLByteString!$fShowConstantTermsSQLByteString0$fShowConstantTermsSQL[]$fShowConstantTermsSQLInt$fShowConstantTermsSQLInt64$fShowConstantTermsSQLInt32$fShowConstantTermsSQLInt16$fShowConstantTermsSQLInt8TableDerivable derivedTableTableunTypename shortNamecolumnsindextoMaybetable AggregateKeyPowerSetListSet OverWindowExists AggregatedFlatConfigproductUnitSupportchunksInsertSizeschemaNameModenormalizedTableNameverboseAsCompilerWarningidentifierQuotation nameConfigIdentifierQuotation NoQuotation QuotationSchemaNameModeSchemaQualifiedSchemaNotQualifiedProductUnitSupport PUSupportedPUNotSupported NameConfig recordConfigrelationVarName defaultConfig QueryConfigrunQueryConfig queryConfigaskQueryConfig$fMonadQueryConfig$fFunctorQueryConfig$fApplicativeQueryConfigOrderAscDescQueryRestriction ProjectionUntypedProjectionProjectionUnit JoinProductProductBuilderNodeAttrJust'Maybe Qualified QualifierSubQuery fromTable flatSubQueryaggregatedSubQueryunionexcept intersectunitSQLshowSQLtoSQL queryWidthcolumn#untypedProjectionFromJoinedSubQueryprojectionColumnsunsafeProjectionStringSql composeWhere composeHavingRelationConfigureQueryconfigureQuery qualifyQuery askConfigunsafeTypeRelationuntypeRelationrightPhleftPhsqlFromRelationWithsqlFromRelationdump$fShowRelationListProjectionunsafeStringSqluntypeunsafeFromQualifiedSubQueryunsafeFromScalarSubQueryunsafeFromTableunsafeFromSqlTermspiMaybepiMaybe' flattenMaybejustunsafeChangeContextunsafeToAggregated unsafeToFlatunsafeStringSqlNotNullMaybelistunsafeListFromSubQueryunsafeStringSqlList"$fProjectableApplicativeProjection$fProjectableFunctorProjection QuerySuffixshowsQuerySuffixupdatePrefixSQL updateSQL'updateOtherThanKeySQL'updateOtherThanKeySQLinsertPrefixSQLinsertSizedChunkSQL insertSQLdeletePrefixSQL'deletePrefixSQLHasConstraintKey constraintKeyKeyindexesunsafeDefineConstraintKeytableConstraint projectionKey uniqueKeyderivedUniqueKey defineProductConstructorInstancedefineTupleProductConstructordefineTupleShowConstantInstance defineTuplePi$fProductConstructor(->)$fProductConstructor(->)0$fProductConstructor(->)1$fProductConstructor(->)2$fProductConstructor(->)3$fProductConstructor(->)4 tuplePi2_0' tuplePi2_1' tuplePi3_0' tuplePi3_1' tuplePi3_2' tuplePi4_0' tuplePi4_1' tuplePi4_2' tuplePi4_3' tuplePi5_0' tuplePi5_1' tuplePi5_2' tuplePi5_3' tuplePi5_4' tuplePi6_0' tuplePi6_1' tuplePi6_2' tuplePi6_3' tuplePi6_4' tuplePi6_5' tuplePi7_0' tuplePi7_1' tuplePi7_2' tuplePi7_3' tuplePi7_4' tuplePi7_5' tuplePi7_6'$fShowConstantTermsSQL(,,,,,,)$fShowConstantTermsSQL(,,,,,)$fShowConstantTermsSQL(,,,,)$fShowConstantTermsSQL(,,,)$fShowConstantTermsSQL(,,)$fShowConstantTermsSQL(,)ProjectableIdZipleftIdrightIdProjectableMaybe PlaceHoldersSqlBinOpProjectableShowSqlunsafeShowSql'SqlProjectableunsafeProjectSqlTermsunsafeProjectSql'unsafeProjectSqlunsafeValueNullvalue valueTrue valueFalsevalues unsafeShowSql unsafeUniOp unsafeBinOp.=..<..<=..>..>=..<>.and'or'not'exists.||.?||?like' likeMaybe'like likeMaybe.+..-../..*.negate' fromIntegral'showNum?+??-??/??*? negateMaybefromIntegralMaybe showNumMaybe caseSearch casesOrElsecaseSearchMaybecase' casesOrElse' caseMaybein' isNothingisJust fromMayberank denseRank rowNumber percentRankcumeDistunsafeAddPlaceHoldersunsafePlaceHoldersunitPlaceHolder placeholder' placeholder projectZip><$$fProjectableApplicativePlaceHolders $fProjectableFunctorPlaceHolders$fProjectableIdZipPlaceHolders$fProjectableMaybeProjection$fProjectableMaybePlaceHolders$fProjectableShowSqlProjection$fOperatorProjectableProjection $fOperatorProjectableProjection0$fSqlProjectableProjection$fSqlProjectableProjection0$fSqlProjectableProjection1MonadPartition partitionByMonadAggregategroupBygroupBy' MonadQualify liftQualify MonadQuerysetDuplication restrictJoinquery' queryMaybe' MonadRestrictrestrictall'distinctonwhereshaving$fMonadQualifyqqPartitioningSetAggregatingSetListAggregatingPowerSetAggregatingSetPartitioningSetTAggregatingPowerSetTAggregatingSetListTAggregatingSetT Aggregatings aggregatingsextractAggregateTermskeykey'setbkeyrollupcube groupingSets$fMonadPartitioncAggregatings$fMonadAggregateAggregatings$fMonadQueryAggregatings$fMonadQualifyqAggregatings$fMonadRestrictcAggregatings$fMonadTransAggregatings$fMonadAggregatings$fFunctorAggregatings$fApplicativeAggregatings AssignTarget Assignings assigningsassignTo<-#extractAssignments$fMonadQualifyqAssignings$fMonadRestrictcAssignings$fMonadTransAssignings$fMonadAssignings$fFunctorAssignings$fApplicativeAssigningsRegisterextract Orderings orderingsorderByascdescextractOrderingTerms$fProjectableOrderingProjection$fMonadPartitioncOrderings$fMonadAggregateOrderings$fMonadQueryOrderings$fMonadQualifyqOrderings$fMonadRestrictrcOrderings$fMonadTransOrderings$fMonadOrderings$fFunctorOrderings$fApplicativeOrderings Restrictings restrictingsextractRestrict$fMonadAggregateRestrictings$fMonadQueryRestrictings$fMonadQualifyqRestrictings$fMonadRestrictcRestrictings$fMonadTransRestrictings$fMonadRestrictings$fFunctorRestrictings$fApplicativeRestrictingsRestrictAssign InsertTarget UpdateTarget Restriction restriction restriction'sqlWhereFromRestriction updateTarget updateTarget'liftTargetAllColumnliftTargetAllColumn'updateTargetAllColumnupdateTargetAllColumn'sqlFromUpdateTarget insertTarget insertTarget'sqlFromInsertTarget$fShowUpdateTarget$fShowRestriction QueryJoinjoin'unsafeSubQueryWithAttrextractProduct$fMonadQueryQueryJoin$fMonadQualifyqQueryJoin$fMonadTransQueryJoin$fMonadQueryJoin$fFunctorQueryJoin$fApplicativeQueryJoin OrderedQuery QueryCore extractCoreWindowAggregatedQueryQueryAggregate toSubQueryover$fMonadRestrictFlatRestrictings SimpleQuery QuerySimplesimple QueryUniqueunsafeUniqueSubQuery$fMonadQualifyQueryUnique$fMonadQueryQueryUnique$fMonadQueryUnique$fApplicativeQueryUnique$fFunctorQueryUniqueProjectableRunIdsZiprunIdsProjectableFlattenMaybeflattenunsafeAggregateOpcountsumMaybesum'avgMaybeavgmaxMaybemax'minMaybemin'everyany'some'!?!?!?flattenPiMaybe!?? flattenPh$fProjectableRunIdsZipaa$fProjectableRunIdsZip(,)b$fProjectableRunIdsZip(,)b0#$fProjectableFlattenMaybeMaybeMaybe$fProjectableFlattenMaybeMaybeb$fAggregatedContextOverWindow$fAggregatedContextAggregatedUniqueRelationJoinRestrictionderivedRelationtableOfquery queryMaybe queryList' queryList relation'relationaggregateRelation'aggregateRelationinner'left'right'full'innerleftrightfullon'unionAll exceptAll intersectAllunion' unionAll'except' exceptAll' intersect' intersectAll' unsafeUniqueunUnique uniqueQuery'uniqueQueryMaybe'uniqueRelation'aggregatedUnique queryScalar' queryScalarUntypeableNoFetch untypeNoFetchDelete untypeDelete InsertQueryuntypeInsertQueryInsert untypeInsert chunkedInsertUpdate untypeUpdate KeyUpdate updateKeyuntypeKeyUpdateQuery untypeQueryunsafeTypedQueryrelationalQuerySQLrelationalQuery'relationalQueryunsafeTypedKeyUpdatetypedKeyUpdatetypedKeyUpdateTableunsafeTypedUpdate updateSQL typedUpdate' typedUpdatederivedUpdate' derivedUpdatetypedUpdateAllColumnrestrictedUpdateAllColumnrestrictedUpdateTableAllColumnuntypeChunkInsertchunkSizeOfInsertunsafeTypedInsert'unsafeTypedInsert typedInsert' typedInsert derivedInserttypedInsertValue'typedInsertValuederivedInsertValue'derivedInsertValueunsafeTypedInsertQueryinsertQuerySQLtypedInsertQuery'typedInsertQueryderivedInsertQueryunsafeTypedDelete deleteSQL typedDelete' typedDeletederivedDelete' derivedDelete$fUntypeableNoFetchDelete$fUntypeableNoFetchUpdate$fUntypeableNoFetchInsertQuery$fUntypeableNoFetchInsert $fShowDelete$fShowInsertQuery $fShowInsert $fShowUpdate$fShowKeyUpdate $fShowQuery specifiedKeyuniqueprimary'primaryupdateValuesWithKeyupdateByConstraintKey primaryUpdatederivedUniqueRelationQueryA queryExists queryExists' queryListU queryListU' queryScalarU queryScalarU'assign$fCategoryQueryA $fArrowQueryAdefineHasPrimaryKeyInstance%defineHasPrimaryKeyInstanceWithConfigdefineHasNotNullKeyInstance%defineHasNotNullKeyInstanceWithConfig defineColumnsdefineColumnsDefaultdefineTableTypesderivationExpDefaulttableVarExpDefaultrelationVarExpdefineTableTypesWithConfigdefineTableTypesAndRecorddefinePrimaryQuerydefinePrimaryUpdatedefineSqlsWithPrimaryKeydefineSqlsWithPrimaryKeyDefault defineTableunsafeInlineQuery reifyRelation inlineQuerymakeRelationalRecordDefault stringSQLbaseGHC.BaseString showStringSQL rowStringSQLrowPlaceHolderStringSQLrowConsStringSQL listStringSQLUntypedname'width' columnArraycolumns'<*>fmapGShowConstantTermsSQLgShowConstantTermsSQLPi'unsafeCastRecordWidthmap definePi'Database.Record.PersistablePersistableRecordWidthLeftestMapunsafePiAppend'unsafePiAppend unsafeCastsnd'' intTermsSQLescapeStringToSqlExpr stringExprSQL time-1.6.0.1Data.Time.Clock.UTCUTCTimeData.Time.LocalTime.LocalTime ZonedTime LocalTimeData.Time.LocalTime.TimeOfDay TimeOfDayData.Time.Calendar.DaysDayghc-prim GHC.TypesDoubleFloatBoolChar#text-1.2.2.1-9Yh8rJoh8fO2JMLWffT3QsData.Text.Internal.LazyTextData.Text.Internalbytestring-0.10.8.1Data.ByteString.Lazy.Internal ByteStringData.ByteString.InternalIntGHC.IntInt64Int32Int16Int8stringTermsSQL floatTermsconstantTimeTermsshowMaybeTerms AggregateElem AggregateSetAggregateBitKeyAggregateColumnRefaggregateColumnRefaggregatePowerKeyaggregateGroupingSetaggregateRollup aggregateCube aggregateSetsaggregateEmptycomposeGroupBycomposePartitionByaggregateKeyProjectionaggregateKeyElementunsafeAggregateKey ColumnRefRollupCube GroupingSetscommaedpCommashowsAggregateBitKey$fShowNameConfigtransformers-0.5.2.0Control.Monad.Trans.ReaderReaderT Assignment AssignTerm AssignColumn OrderingTerm OrderColumn DuplicationshowsDuplicationcomposeOrderBy composeSets composeValuesAllDistinctuntypeProjection RawColumn SubQueryRefScalarCase CaseClause WhenClausesProductTreeBuilderQueryProductTreeNode ProductTreeBinOpSetOp qualifier unQualifyqualifynodeAttrnodeTreeuntypedProjectionWidthtypedProjectionprojectionWidthprojectFromColumnsprojectFromScalarSubQuery CaseSearch CaseSimpleLeafJoinQueryRestrictionBuilderQSBinUnionExcept Intersect whenClauses growRight growProductrestrictProduct'restrictProduct JoinContextprimeJoinContext updateProduct joinProductproductQualifyevalQualifyPrimenewAliasfromTableToSQLfromTableToNormalizedSQL normalizedSQLtoSQLs showQualifier columnFromIdqualifiedSQLasindexWhensClause caseClausecolumnOfProjectionUnitcolumnOfUntypedProjectionshowsQueryProductshowsJoinProductcomposeRestrict showsSetOp' showsSetOpsetBinselectPrefixSQL showUnitSQLcolumnN asColumnNunsafeCastPlaceHolder unsafeProjectListSubnotNullMaybeConstraintinsertChunkSQL KeyConstraintunsafeReturnKey mapConstrainttupleNtuplePi compareBinOp monoBinOp monoBinOp'unsafeCastPlaceHoldersOperatorProjectableunsafeFlatUniOp unsafeLikeunsafeCastProjectableunsafeUniTermFunctionunsafeProjectPlaceHolder'unsafeProjectPlaceHolderunsafeAggregateWithTerm aggregateKeyextractTermList finalizePowertargetProjectionProjectableOrderingupdateOrderBys orderTermsupdateRestrictionrunRestriction_runUpdateTargetupdateAllColumnControl.Monad.Trans.State.LazyStateT updateContextupdateJoinRestriction queryWithAttr extractWindowAggregatedContextjoin_uniqueQueryWithAttrplaceHoldersFromRelation queryList0 addUnitPHunsafeLiftAppend liftAppend liftAppend' targetTablerestrictedTablequeryA runQueryArunAofMunsafeQueryListunsafeQueryList'unsafeQueryScalarunsafeQueryScalar'defineHasConstraintKeyInstancecolumnTemplate'columnTemplatedefineTableDerivableInstancedefineTableDerivations*defineProductConstructorInstanceWithConfigdefineWithPrimaryKeydefineWithNotNullKeyWithConfigtableSQLquotederivationVarNameDefaulttableVarNameDefault