ID      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJ K L M N O P Q R S T U V W X YZ[\]^_`ab c d e f g h i j k l m 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"'#2014 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknown Safe-InferredD!String wrap type for SQL strings.ED from F.GD to F.HRow String of SQL values.IPlace holder row String of SQL.JList String of SQL.KList String of SQL.DEGHIJKDEGHIJKDEGHIJK2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknown Safe-InferredBPhantom typed SQL expression object. Project from projection type p.%Get SQL expression from typed object.!Get SQL string from typed object.LShow expression.LL2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone24*Constraint which represents scalar degree. instance templates.MM2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknown Safe-Inferred #Type tag for aggregatings power set 'Type tag for aggregatings GROUPING SETS $Type tag for normal aggregatings set %Type tag for window function building Type tag for exists predicateType tag for aggregated query(Type tag for flat (not-aggregated) query    2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone24%Interface for constant SQL term list.CSpecify tuple like record constructors which are allowed to define ProjectableFunctor.The constructor which has type r.N!Constant integral SQL expression.OEscape F$ for constant SQL string expression.PFrom F% into constant SQL string expression.String interface of .Q$Constant SQL terms of '(a, b)' type.RConstant SQL terms of S# type. Width inference is required.TConstant SQL terms of U.VConstant SQL terms of W.XConstant SQL terms of Y.ZConstant 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 a.bConstant SQL terms of c.dConstant SQL terms of e.fConstant SQL terms of g.hConstant SQL terms of i.jConstant SQL terms of F.kConstant SQL terms of lU. Use this carefully, because this is architecture dependent size of integer type.mConstant SQL terms of n.oConstant SQL terms of p.qConstant SQL terms of r.s$ProductConstructor instance of pair. NtOPuvwxQRTVXZ\^`bdfhjkmoqsNtOPuvwxQRTVXZ\^`bdfhjkmoqs2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone241Typed constant SQL expression from Haskell value.yUnsafely cast phantom type.Convert phantom type into S.!Allowed only for having or where {. So NULL expression result will be possible. Behavior around boolean is strongly dependent on RDBMS impelemetations.AND operator for .yy2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone24'Assignment pair list.Assignment pairValue SQL StringColumn SQL StringType for order-by termsType for order-by termType for order-by column )Order direction. Ascendant or Descendant.#Type for group-by tree$Type for grouping set%Type for group key.&Type for group-by term'Type for restriction of query.(#Result record duplication attribute+$Unit of product is supported or not..Configuration type.2Column SQL string typezSimple wrap type32 from string42 from D{String from ColumnSQL5StringSQL from ColumnSQL6Default configuration.7%Compose duplication attribute string.|Compose SQL String from '.8Compose WHERE clause from '.9Compose HAVING clause from '.: Single term aggregation element.;Key of aggregation power set.<Single grouping set.=Rollup aggregation element.>Cube aggregation element.?Grouping sets aggregation.@Empty aggregation.A0Compose GROUP BY clause from AggregateElem list.B9Compose PARTITION BY clause from AggregateColumnRef list.C*Compose ORDER BY clause from OrderingTermsDCompose SET clause from .ECompose OVER (PARTITION BY ... ) clause.> !"#}~$%&'()*+,-./012z34{567|89:;<=>?@ABCDE- !"#$%&'()*+,-./0123456789:;<=>?@ABCDE-2345./016+-,(*)7'89&%$#:@;<=>?AB "!CDE- "!#~}$%&'(*)+-,./012z34{567|89:;<=>?@ABCDE2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneBF. type to require query generate configuration.GRun F to expand with configurationHLift to F.IRead configuration.FGHIFGHIFHGIFGHI$2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone .Product node. node attribute and product tree.KProduct tree type. Product tree is constructed by left node and right node.node attribute for product.Get node attribute.Get tree from node.7Make product node from node attribute and product tree.&Push new tree into product right term.+Push new leaf node into product right term.Just make product of two node.1Add restriction into top product of product tree.6Add restriction into top product of product tree node. Foldable instance of ProductTreeNode attribute Product tree Result node Current treeNew tree to push into right Result node Current treeNew leaf to push into right Result node Left node Right nodeJoin restriction Result treeProduct to restrictRestriction to addResult product)Target node which has product to restrictRestriction to add Result node  2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone3:MJProjection 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.K&Unsafely untype key to expand indexes.MUnsafely cast width proof object of record. Result record must be same width.LProjectable fmap of J type.MProjectable ap of J type.Get record width proof object.NGet record width.OCompose projection path.PCompose projection path. S phantom functor is -ed.QCompose projection path. S phantom functors are join -ed like >=>.R$Unsafely project untyped value list.*Unsafely define projection path from type r0 into type r1.S*Unsafely define projection path from type r0 into type r1. Use inferred .T*Unsafely define projection path from type r0 into type r1.U*Unsafely define projection path from type r0 into type r1. Use inferred .JKLMNOPQRIndex of flat SQL value listResult projection pathSIndex of flat SQL value listResult projection pathTIndexes of flat SQL value listResult projection pathUIndexes of flat SQL value listResult projection path JKLMNOPQRSTU JLMNOPQRSTUKJKLMNOPQRSTUOPQ 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneVIdentity projection path.W!Projection path for fst of tuple.X!Projection path for snd of tuple.VWProjection path of fst.XProjection path of snd. JLMOPQVWX JLMOPQVWXVWX2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone2346 Y Constraint [ inference interface.ZInfer 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 [aInfered  constraint [. Record type r has unique key which type is ct derived from primay key. YZ[\]-Key indexes which specify this constraint key"Result constraint key proof object^_`a YZ[\]^_`a [\]^_`YZa YZ[\]^_`a 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNonebInference rule of d existence.dPhantom typed table typeeUntyped typed table typefName string of table in SQLgWidth of tableColumn name strings in SQLhColumn name strings in SQLi,Column name string in SQL specified by indexj Untype table.kName string of table in SQLl)Not qualified name string of table in SQLmWidth of tablenColumn name strings in SQLo,Column name string in SQL specified by indexpCast phantom type into S type.q+Unsafely generate phantom typed table type.bcdefghi Column indexColumn name String in SQLjklmno Column indexColumn name String in SQLpqbcdefghijklmnopqefghidjklmnoqpbcbcdefghijklmnopq 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone+rType for join product of query.sProduct node specialized by z.tProduct tree specialized by z.u'Untyped projection. Forgot record type.vProjection structure unitwQualified query.xQualifier type.zSub-query type{z from d.|Unsafely generate flat z from untyped components.}Unsafely generate aggregated z from untyped components.~Union binary operator on zExcept binary operator on zIntersect binary operator on z Width of z.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. Get qualifier Unqualify. Add qualifierAlias string from qualifierBinary operator to qualify.9Qualified expression from qualifier and projection index.From w SQL string into F. Width of w SubQUery.Get column SQL string of z.1Get qualified SQL string, like (SELECT ...) AS T0%Make untyped projection from columns..Make untyped projection from scalar sub-query..Make untyped projection from joined sub-query.ProjectionUnit width.Get column of ProjectionUnit. Width of u.Get column SQL string of u.)Get column SQL string list of projection.6Show product tree of query into SQL. StringSQL result.Shows join product of query. instance of wDrstuvwxyz{Typed d metadataResult z|}~sub-query SQL and top-level SQLSource  Projection Column indexResult SQL stringSource  ProjectionResult SQL string listrstuvwxyz{|}~z{|}~xywvutsr7rstuvwxyz{|}~%2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneJoinContext type for QueryJoin.Initial .Update product of .Update product of .6Finalize context to extract accumulated query product.&2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneB&Monad type to qualify SQL table forms.8Run qualify monad with initial state to get only result.*Generated new qualifier on internal state.Lift to Get qualifyed table form query.Query to qualifyResult with updated state 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone3Projection type for row list.=Phantom typed projection. Projected into Haskell record type t. Width of .)Get column SQL string list of projection. Unsafely get untyped projection.Unsafely generate  from SQL string list.Unsafely generate # from qualified (joined) sub-query.Unsafely generate  from scalar sub-query.Unsafely generate unqualified  from d.Lift  to  to use as restrict predicate.Unsafely get SQL term from  Proejction.Unsafely generate  from SQL expression strings.Unsafely trace projection path.&Trace projection path to get narrower .&Trace projection path to get narrower . From S type to S type.&Trace projection path to get narrower . From S type to S* type. Leaf type of projection path is S.Composite nested S on projection phantom type. Cast into S 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  type.Projectable ap of  type.Make row list projection from  list.Make row list projection from z.IMap projection show operatoions and concatinate to single SQL expression."Source Result SQL string list!SQL string list specifies columnsResult Source Projection path Narrower Source . S typeProjection path Narrower . S type resultSource . S typeProjection path. S type leaf Narrower . S type result2013 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."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 SQLRecords 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 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone234c*Weaken applicative functor on projections. Method like <*>.Weaken functor on projections. Method like .)Zipping except for identity element laws.Interface to control S of phantom type in projections."Cast projection phantom type into S.Compose nested S 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.2Project from Projection type into expression type.7Unsafely project from SQL strings. String interface of .!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.LUnsafely make number 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 ENDSame 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 ENDUncurry 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. ROW_NUMBER() term.PERCENT_RANK() term. CUME_DIST() term..Unsafely add placeholder parameter to queries."Unsafely get placeholder parameterNo placeholder semantics)Unsafely cast placeholder parameter type.;Provide scoped placeholder and return its parameter object.LProvide scoped placeholder and return its parameter object. Monadic version.Zipping projections.Binary operator the same as .Same as . other than using inferred record constructor.Compose projection path J6 which has record result type using applicative style. Compose seed of projection path J which has record result type.Compose record type  using applicative style.Compose seed of record type .Compose record type  using applicative style.Compose seed of record type .LZipping except for identity element laws against placeholder parameter type.Control phantom S type in SQL expression type .Control phantom S type in projection type .Control phantom S type in placeholder parameters.Unsafely get SQL term from  Proejction.Unsafely get SQL term from .Unsafely make  from SQL terms.Unsafely make  from SQL terms.Unsafely make  from SQL terms.Unsafely make  from SQL terms.r Source projection objectResult SQL expression string. SQL expression stringsResult projection objectSQL expression stringsResult projection objectSource projection objectResult SQL expression string.    Error tagEach when clausesElse result projectionResult projectionEach when clausesElse result projectionResult projectionEach when clausesElse result projectionResult projectionEach when clausesResult projectionProjection value to matchEach when clausesElse result projectionResult projection4Projection value to match and each when clauses listElse result projectionResult projectionProjection value to matchEach when clausesResult projectionQQi     2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone23463Interface to run recursively identity element laws.Interface to compose phantom S nested type.Projection interface.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.^Get narrower projection along with projection path and project into result projection type.bGet narrower projection along with projection path and project into result projection type. S phantom functor is -ed.pGet narrower projection along with projection path and project into result projection type. Source record S* phantom functor and projection path leaf S functor are join-ed.JGet narrower projected expression along with projectino path and strip S phantom type off.JGet narrower projected expression along with projectino path and strip S. phantom type off. Projection path leaf is S case.YGet narrower projection with flatten leaf phantom Maybe types along with projection path.Get narrower projection with flatten leaf phantom Maybe types along with projection path and project into result projection type. Specialize  for  type.>Base case definition to run recursively identity element laws.Run right identity element law.Run left identity element law.Not S type is not processed.Compose S! type in projection phantom type. Project from  into  . Project from  into .)      !"Source projectionProjection pathNarrower projected objectSource . S typeProjection pathNarrower projected object. S type resultSource . S phantom typeProjection path. S type leafNarrower projected object. S phantom type resultSource projection type p. S phantom typeProjection pathNarrower projected expression. S phantom type is stripped offSource projection type p. S phantom typeProjection path. S type leafNarrower projected expression. S phantom type is stripped offSource . S phantom typeProjection path Narrower  . Flatten S phantom type#Source . S phantom typeProjection path Narrower  . Flatten S phantom typeSource . S phantom typeProjection path&Narrower flatten and projected object.$%          &      !"#$%2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone36(Window specification building interface.,Aggregated query building interface extends %. Add group by1 term into context and get aggregated projection.!SLift interface from base qualify monad. Another constraint to support unique query."Lift from qualify monad q into %* m. Qualify monad qualifies table form z.#'Lift interface from base qualify monad.$Lift from qualify monad q into %* m. Qualify monad qualifies table form z.%Query building interface.&Specify duplication.'Add restriction to last join.)Restrict context interface* Add restriction to this context.+'Specify ALL attribute to query context.,,Specify DISTINCT attribute to query context.-Add restriction to last join..6Add restriction to last join. Projection type version./1Add restriction to this query. Expr type version.0-Add restriction to this not aggregated query.1Add GROUP BY1 term into context and get aggregated projection.2<Add restriction to this aggregated query. Expr type version.3MAdd restriction to this aggregated query. Aggregated Projection type version.0Partitioning key to add into partition by clauseResult context ,Grouping element to add into group by clauseResult context!"#$%&' which represent restrictionDRestricted query context | Unsafely join sub-query with this query.(Attribute maybe or justz to joinResult joined context and z result projection.)* which represent restrictionRestricted query context+,-./01Projection to add into group by(Result context and aggregated projection23 !"#$%&'()*+,-./0123#$!")*%&'( +,-./0123 !"#$%&'()*+,-./01232013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone246B4/Context monad type to build partition keys set.5.Context monad type to build grouping set list.6/Context monad type to build grouping power set.70Context monad type to build single grouping set.8Typeful aggregate element.9)Context type building partition keys set.:&Context type building power group set.;)Context type building grouping sets list.<'Context type building one grouping set.=0Type 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.>Lift to =.?Run = to get terms list.@Add GROUP BY4 element into context and get aggregated projection.A3Specify key of single grouping set from Projection.B#Specify key of single grouping set.C)Finalize and specify single grouping set.D)Specify key of rollup and cube power set.E0Finalize grouping power set as rollup power set.F.Finalize grouping power set as cube power set.GFinalize grouping set list.&Partition clause instance'Aggregated query instance.( Aggregated %.) Aggregated ).45678*9:;<=+>,?@-ABCD.EFG&'()456789:;<=>?@ABCDEFG=><;:9?8@7654ABCDEFG45678*9:;<=+>,?@-ABCD.EFG&'()2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone2346B /(Ordering term projection type interface.H-Type to accumulate ordering context. Type c* is ordering term projection context type.ILift to H.0Add ordering terms.JAdd ordering terms.KAdd ascendant ordering term.LAdd descendant ordering term.MRun H to get 1 is ordering term.2 with ordering.3 with ordering.4% with ordering.5) with ordering./6H7I0Order directionOrdering terms to addResult context with orderingJOrdering terms to addOrder directionResult context with orderingKOrdering terms to addResult context with orderingLOrdering terms to addResult context with orderingM12345HIJKLMHIJKLM /6H7I0JKLM123452013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone246BNTarget of assignment.O.Type to accumulate assigning context. Type r is table record type.PLift to OQAdd an assignment.RAdd and assginment.SRun O to get 8) with ordering. NO9P:QRS8NOPQRSOPQRNSNO9P:QRS8R2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone246BT/Type to accumulate query restrictions. Type cT is context tag of restriction building like Flat (where) or Aggregated (having).ULift to T;Add whole query restriction.VRun T to get '< Resticted  instance.= Restricted % instance.>) instance.T?U;V<=>TUVTUVT?U;V<=>2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneBW@) type to accumulate join product context.XLift to WA%Unsafely update join product context.B"Add last join product restriction.C(Unsafely join sub-query with this query.YRun W to get rDJoinable query instance. WEXABCAttribute maybe or justz to joinResult joined context and z result projection.YDFWXYWXYWEXABCYDF2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneZ.OrderedQuery monad type with placeholder type p!. Projection must be the same as H context type parameter c.[PCore query monad type used from flat(not-aggregated) query and aggregated query.\&Thin monad type for untyped structure.]Run \- monad with initial state to get only result.^Get qualifyed table form query._Read configuration.`Extract [ computation.Z[\]^_`Z[\]^_`\]^_[`ZZ[\]^_`2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone246a<RestrictedStatement type synonym. Projection record type r must be the same as T type parameter r.bIRestrict only monad type used from update statement and delete statement.cRun b to get '.G1Instance to lift from qualified table forms into b.abcGabcbacabcG2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone246dAssignStatement type synonym. Specifying assignments and restrictions like update statement. Projection record type must be the same as Target type parameter r.eHTarget update monad type used from update statement and merge statement.fRun e.H1Instance to lift from qualified table forms into b.defHdefedfdefH2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNonegNot finalized Target monad type.h.UpdateTarget type with place-holder parameter p and projection record type r.iNot finalized b monad type.j-Restriction type with place-holder parameter p and projection record type r.k Finalize b monad and generate j.l Finalize b monad and generate j with place-holder parameter pmSQL WHERE clause D string from j.n Finalize Target monad and generate h.o Finalize Target monad and generate h with place-holder parameter p.pLift j to h . Update target columns are all.qLift j to h7. Update target columns are all. With placefolder type p.r Finalize b monad and generate h . Update target columns are all.s Finalize b monad and generate h7. Update target columns are all. With placefolder type p.t SQL SET clause and WHERE clause D string from hIShow where clause.ghJijKklLmnoMNpqrstOIghijklmnopqrstjiklhgnopqrsmtghJijKklLmnoMNpqrstOI2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone246u$Simple (not-aggregated) query type.  SimpleQuery' p r == v ( p,  r).v)Simple (not-aggregated) query monad type.w%Lift from qualified table forms into v.xRun u to get SQL string with Qualify computation.yRun u to get z with Qualify computation.P1Instance to lift from qualified table forms into v.uvwQxu to runResult SQL string with Qualify computationy SimpleQuery' to runResult z with Qualify computationPuvwxyvuwxyuvwQxyP2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone2346 z-Partition monad type for partition-by clause.{Aggregated query type. { p r == | ( p,   r).|Aggregated query monad type.R%Lift from qualified table forms into |.}Run { to get SQL with \ computation.~Run { to get z with \ computation.Add  PARTITION BY term into context.?Operator to make window function result projection using built z monad.S1Instance to lift from qualified table forms into |.T Restricted ) instance. z{|RU}{ to runResult SQL string with \ computation~{ to runResult z with \ computationVSTz{|}~|{}~z z{|RU}~VST2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone246BUnique query monad type.W%Lift from qualified table forms into .Run  SimpleQuery to get z with Qualify computation.X1Instance to lift from qualified table forms into .YWZ to runResult z with Qualify computationXYWZX2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone37/Unique relation type to compose scalar queries.9Restriction function type for direct style join operator.*Relation type with place-holder parameter p and query result type r.Simple  from d.Infered .Interface to derive d type object.[&Sub-query Qualify monad from relation.\#Basic monadic join operation using %.+Join sub-query with place-holder parameter p. query result is not S.$Join sub-query. Query result is not S.+Join sub-query with place-holder parameter p. Query result is S. Join sub-query. Query result is S. 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 v monad and generate  with place-holder parameter p. Finalize v monad and generate . Finalize | monad and geneate  with place-holder parameter p. Finalize | monad and geneate .9Simplify placeholder type applying left identity element.:Simplify placeholder type applying right identity element.]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.Generate SQL string from  with configuration.SQL string from .Dump internal structure tree.!Unsafely specify unique relation.Discard unique attribute._#Basic monadic join operation using %.2Join unique sub-query with place-holder parameter p.2Join unique sub-query with place-holder parameter p. Query result is S. Finalize  monad and generate . Aggregated .-Scalar sub-query with place-holder parameter p.Scalar sub-query.A`ab[\cde]Left 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^Left 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 relationfgh_i22?`ab[\cde]^fgh_i2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone-zUntype 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.'Query type with place-holder parameter p and query result type a.Unsafely make typed  from SQL string.From  into untyped SQL query string.From  into typed  with suffix SQL words.From  into typed .Unsafely make typed  from SQL string. Make typed  from d and key columns selector J. Make typed ( object using derived info specified by  type.Unsafely make typed  from SQL string.$Make untyped update SQL string from d and h. Make typed  from ., d and h. Make typed  using 6, d and h. Make typed  from ., derived table and g Make typed  from 6, derived table and g Make typed  from d and j!. Update target is all column.Directly make typed  from d and Restrict/ monad context. Update target is all column.Directly make typed  from d and Restrict/ monad context. Update target is all column.Unsafely make typed + from single insert and chunked insert SQL.Unsafely make typed  from single insert SQL. Make typed  from d and columns selector J with configuration parameter. Make typed  from d and columns selector J.Table type inferred .Unsafely make typed  from SQL string.+Make untyped insert select SQL string from d, J and . Make typed  from columns selector d, J and  with configuration parameter. Make typed  from columns selector d, J and .Table type inferred .Unsafely make typed  from SQL string.$Make untyped delete SQL string from d and j. Make typed  from ., d and j. Make typed  from d and j. Make typed  from ., derived table and RestrictContext Make typed  from 6, derived table and RestrictContextjShow delete SQL stringkShow insert SQL string.lShow insert SQL string.mShow update SQL stringnShow update SQL stringoShow query SQL stringBQuery SQL to type Typed resultpRestrict monad contextqrstjklmno772pqrstjklmno 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone3$Query restricted with specified key.+Query restricted with specified unique key.,Query restricted with specified primary key.+Query restricted with inferred primary key.Convert 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.Typed  using specified constraint key.Typed  using inferred primary key. inferred from table.-Unique key proof object which record type is a and key type is p. to add restriction.Result restricted -Unique key proof object which record type is a and key type is p. to add restriction.Result restricted .Primary key proof object which record type is a and key type is p. to add restriction.Result restricted  to add restriction.Result restricted d to updateKey with constraint c, record type r and columns type p Result typed Updated to update Result typed Update-Unique key proof object which record type is a and key type is p.Unique key value to specify.Result restricted '2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneG  !"+,-./016JLMOPQVWXYZ[^_`abcdz     #%)*+,-./0123@ABCDEFGJKLQRZ[\]^_`beghijklmnopqrstuvz{|!2015 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone3B:Arrow type corresponding to iArrow type corresponding to gArrow type corresponding to OArrow type corresponding to zArrow type corresponding to HArrow type corresponding to 6Arrow type corresponding to 5Arrow type corresponding to 7Arrow type corresponding to Arrow type corresponding to |Arrow type corresponding to vArrow to build queries.Same as +. Arrow version.Same as ,. Arrow version.Same 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 N. Arrow version. The result arrow is not injected by any local projections.Same as N. 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 .f. Arrow version. The result arrow is designed to be injected by local conditional flat-projections.Same as 0f. Arrow version. The result arrow is designed to be injected by local conditional flat-projections.Same as 3l. Arrow version. The result arrow is designed to be injected by local conditional aggregated-projections.Same as 1Z. Arrow version. The result arrow is designed to be injected by local flat-projections.Same as j. 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 @4. This arrow is designed to be injected by local 8.Same as AE. This arrow is designed to be injected by local flat-projections.Same as B4. This arrow is designed to be injected by local  AggregteKey.Same as C<. This arrow is designed to be injected by locally built  AggregtingSet arrow. Same as DE. This arrow is designed to be injected by local flat-projections.!Same as E. Finalize locally built ."Same as F. Finalize locally built .#Same as G. Finalize locally built .$Same as JF. The result arrow is designed to be injected by local projections.%Same as KF. The result arrow is designed to be injected by local projections.&Same as LF. 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 8. Make window function result projection using built  arrow.)Make NN 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  . Make 3 from restrict statement arrow using configuration.-Same as  . Make  from restrict statement arrow.Buvwxyz   {|   !"#$%&'()*+,-T  !"+,-./016JLMOPQVWXYZ[^_`abcdz     #%)*-/2QRZ[\]^_`behjklmnopqrstu{      !"#$%&'()*+,-:      !"#$%&'()*+,-Auvwxyz   {|   !"#$%&'()*+,-("2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone246?M}&Rule template to infer constraint key..#Rule template to infer primary key./#Rule template to infer primary key.0$Rule template to infer not-null key.1$Rule template to infer not-null key.~Column projection path J template.Column projection path J and constraint key template.2Column projection path J templates.3SMake 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.4d and  templates.5Make TableDerivationH variable expression template from table name using default naming rule.6Make dH variable expression template from table name using default naming rule.7Make H variable expression template from table name using default naming rule.8Make template for  instance.Make template for record $ instance using default naming rule.9JMake templates about table and column metadatas using default naming rule.:PMake templates about table, column and haskell record using default naming rule.;Template of derived primary .<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 default naming rule.@Unsafely inlining SQL string  in compile type.A8Extract param type and result type from defined RelationBInlining composed  in compile type.CnGenerate all templates against defined record like type constructor other than depending on sql-value type."}Constraint type Record typeKey typeIndexes specifies keyResult Y declaration. Record typeKey typeIndexes specifies key"Result constraint key declarations/ Table name Column typePrimary key index&Declarations of primary constraint key0 Record type Column indexResult ColumnConstraint declaration1 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 declaration2Record type nameColumn info list#Column projection path declarations3Record 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 declaration4Table 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 declaration5Table name stringResult var Exp6Table name stringResult var Exp7Table name stringResult var Exp89$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 Record type of  expressionResult  declaration<#Variable name of result declarationParameter type of UpdateRecord type of Updated expressionResult Update declaration=9Variable name of select query definition from primary key=Variable name of update statement definition from primary keyPrimary key type Record typeRelation expressionTable expressionResult declarations>Table name of DatabasePrimary key type Record typeRelation expressionTable expressionResult declarationsTable 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 declarations@Query parameter typeQuery result typeSQL string query to inlineVariable name for inlined queryResult declarationsA%Variable name which has Relation type7Extracted param type and result type from Relation typeB"Top-level variable name which has  typeObject which has  typeConfiguration to generate SQLsuffix SQL words(Variable name to define as inlined queryResult declarationsCType constructor nameResult declaration./0123456789:;<=>?@ABC?@B:./012349;<567=>8CA"}./01~23456789:;<=>?@ABC()*()+(),--./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqr s t u v w x y z { | } ~      w          w   w . { ? u v ?      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~        !!!k!!d!R!Q!S!!!!!G!H!!!!!!!!!!!!!!!!!J!L!O!M!!!!!!!\!]!^!_!`!a!b!c!f!g!h!!!!!!!" " " " " """""""""""""""""## !"##$#%#&#'#()*+,-./!012345637893:;<=>?@=>AB=>CD=>EFGHIJGKILMNOPMQORS=>TU!VWX!VYZ!V[\]^_`abcdefghiMNW[jklmnopqro$s$t$u$v$w$x$y$z${$|$}$~$s$$$1$$-   !" ( s      w()         x         !"      7 8                 %%%%%%%{&&&&&z&&         !"TYdk  pp   s t!"*#$%&'()*+,-./012345!!6!7!8!9!:!;!<"=">"?"@"A"B"C"D"E"F"G"HIrelational-query-0.5.2.0$Database.Relational.Query.Constraint%Database.Relational.Query.Expr.Unsafe Database.Relational.Query.Scalar!Database.Relational.Query.ContextDatabase.Relational.Query.PureDatabase.Relational.Query.Expr#Database.Relational.Query.Component,Database.Relational.Query.Monad.Trans.Config#Database.Relational.Query.Pi.UnsafeDatabase.Relational.Query.PiDatabase.Relational.Query.TableDatabase.Relational.Query.Sub$Database.Relational.Query.ProjectionDatabase.Relational.Query.SQL%Database.Relational.Query.Projectable-Database.Relational.Query.ProjectableExtended%Database.Relational.Query.Monad.Class1Database.Relational.Query.Monad.Trans.Aggregating.Database.Relational.Query.Monad.Trans.Ordering/Database.Relational.Query.Monad.Trans.Assigning1Database.Relational.Query.Monad.Trans.Restricting*Database.Relational.Query.Monad.Trans.Join$Database.Relational.Query.Monad.Type(Database.Relational.Query.Monad.Restrict&Database.Relational.Query.Monad.Assign Database.Relational.Query.Effect&Database.Relational.Query.Monad.Simple)Database.Relational.Query.Monad.Aggregate&Database.Relational.Query.Monad.Unique"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.Product/Database.Relational.Query.Monad.Trans.JoinState-Database.Relational.Query.Monad.Trans.QualifyDatabase.Relational.Querypersistable-record-0.1.0.1Database.Record.KeyConstraintUniqueNotNullPrimaryExprunsafeStringSqlshowExpr ScalarDegreedefineScalarDegreePowerSetListSet OverWindowExists AggregatedFlatShowConstantTermsSQLshowConstantTermsSQL'ProductConstructorproductConstructorshowConstantTermsSQL valueExprjustfromJustexprAnd Assignments Assignment AssignTerm AssignColumn OrderingTerms OrderingTerm OrderColumnOrderDescAsc AggregateElem AggregateSetAggregateBitKeyAggregateColumnRefQueryRestriction DuplicationDistinctAllProductUnitSupportPUNotSupported PUSupportedConfigproductUnitSupportchunksInsertSizenormalizedTableName ColumnSQL columnSQL columnSQL'showsColumnSQL defaultConfigshowsDuplication composeWhere composeHavingaggregateColumnRefaggregatePowerKeyaggregateGroupingSetaggregateRollup aggregateCube aggregateSetsaggregateEmptycomposeGroupBycomposePartitionBycomposeOrderBy composeSets composeOver QueryConfigrunQueryConfig queryConfigaskQueryConfigPiunsafeExpandIndexespfmappapwidth<.>pidefinePidefineDirectPi'defineDirectPiid'fst'snd'HasConstraintKey constraintKeyKeyindexesunsafeDefineConstraintKeytableConstraint projectionKey uniqueKeyderivedUniqueKeyTableDerivable derivedTableTableUntypedname'width'columns'!unTypename shortNamecolumnsindextoMaybetable JoinProductQueryProductNode QueryProductUntypedProjectionProjectionUnit Qualified QualifierSubQuery fromTable flatSubQueryaggregatedSubQueryunionexcept intersectunitSQLshowSQLtoSQL qualifier unQualifyqualify queryWidthcolumnuntypedProjectionFromColumns#untypedProjectionFromScalarSubQuery#untypedProjectionFromJoinedSubQuerywidthOfUntypedProjectioncolumnsOfUntypedProjectionListProjection ProjectionuntypeunsafeFromQualifiedSubQueryunsafeFromScalarSubQueryunsafeFromTablepredicateProjectionFromExprunsafeFromSqlTermspiMaybepiMaybe' flattenMaybeunsafeChangeContextunsafeToAggregated unsafeToFlatunsafeStringSqlNotNullMaybelistunsafeListFromSubQueryunsafeStringSqlList QuerySuffixshowsQuerySuffixupdatePrefixSQL updateSQL'updateOtherThanKeySQL'updateOtherThanKeySQLinsertPrefixSQLinsertSizedChunkSQL insertSQLdeletePrefixSQL'deletePrefixSQLProjectableApplicative|*|ProjectableFunctor|$|ProjectableIdZipleftIdrightIdProjectableMaybe PlaceHoldersSqlBinOpProjectableShowSqlunsafeShowSql'SqlProjectableunsafeProjectSqlTerms'exprunsafeProjectSqlTermsunsafeProjectSql'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><ipfmapProjectableRunIdsZiprunIdsProjectableFlattenMaybeflattenunsafeAggregateOpcountsumMaybesum'avgMaybeavgmaxMaybemax'minMaybemin'everyany'some'?!?!?.!.?flattenPiMaybe!?? flattenPhMonadPartitionunsafeAddPartitionKeyMonadAggregateunsafeAddAggregateElementMonadQualifyUniqueliftQualifyUnique MonadQualify liftQualify MonadQuerysetDuplication restrictJoinunsafeSubQuery MonadRestrictrestrictall'distinctonEonwheresEwheresgroupByhavingEhavingPartitioningSetAggregatingSetListAggregatingPowerSetAggregatingSet AggregateKeyPartitioningSetTAggregatingPowerSetTAggregatingSetListTAggregatingSetT Aggregatings aggregatingsextractAggregateTermsgroupBy'keykey'setbkeyrollupcube groupingSets Orderings orderingsorderByascdescextractOrderingTerms AssignTarget Assignings assigningsassignTo<-#extractAssignments Restrictings restrictingsextractRestrict QueryJoinjoin'extractProduct OrderedQuery QueryCoreConfigureQueryconfigureQuery qualifyQuery askConfig extractCoreRestrictedStatementRestrictextractAssignStatementAssignUpdateTargetContext UpdateTargetRestrictionContext Restriction restriction restriction'sqlWhereFromRestriction updateTarget updateTarget'liftTargetAllColumnliftTargetAllColumn'updateTargetAllColumnupdateTargetAllColumn'sqlFromUpdateTarget SimpleQuery QuerySimplesimple toSubQueryWindowAggregatedQueryQueryAggregate partitionByover QueryUniqueUniqueRelationJoinRestrictionRelationderivedRelationtableOfquery'query queryMaybe' queryMaybe queryList' queryList relation'relationaggregateRelation'aggregateRelationrightPhleftPhinner'left'right'full'innerleftrightfullon'unionAll exceptAll intersectAllunion' unionAll'except' exceptAll' intersect' intersectAll'sqlFromRelationWithsqlFromRelationdump unsafeUniqueunUnique uniqueQuery'uniqueQueryMaybe'uniqueRelation'aggregatedUnique queryScalar' queryScalarUntypeableNoFetch untypeNoFetchDelete untypeDelete InsertQueryuntypeInsertQueryInsert untypeInsertuntypeChunkInsertchunkSizeOfInsertUpdate untypeUpdate KeyUpdate updateKeyuntypeKeyUpdateQuery untypeQueryunsafeTypedQueryrelationalQuerySQLrelationalQuery'relationalQueryunsafeTypedKeyUpdatetypedKeyUpdatetypedKeyUpdateTableunsafeTypedUpdate updateSQL typedUpdate' typedUpdatederivedUpdate' derivedUpdatetypedUpdateAllColumnrestrictedUpdateAllColumnrestrictedUpdateTableAllColumnunsafeTypedInsert'unsafeTypedInsert typedInsert' typedInsert derivedInsertunsafeTypedInsertQueryinsertQuerySQLtypedInsertQuery'typedInsertQueryderivedInsertQueryunsafeTypedDelete deleteSQL typedDelete' typedDeletederivedDelete' derivedDelete specifiedKeyuniqueprimary'primaryupdateValuesWithKeyupdateByConstraintKey primaryUpdatederivedUniqueRelationQueryA queryExists queryExists' queryListU queryListU' queryScalarU queryScalarU'assigndefineHasPrimaryKeyInstance"defineHasPrimaryKeyInstanceDefaultdefineHasNotNullKeyInstance"defineHasNotNullKeyInstanceDefault defineColumnsdefineColumnsDefaultdefineTableTypesderivationExpDefaulttableVarExpDefaultrelationVarExpDefault defineProductConstructorInstancedefineTableTypesDefault defineTableTypesAndRecordDefaultdefinePrimaryQuerydefinePrimaryUpdatedefineSqlsWithPrimaryKeydefineSqlsWithPrimaryKeyDefaultdefineTableDefaultunsafeInlineQuery reifyRelation inlineQuerymakeRelationalRecordDefault StringSQL stringSQLbaseGHC.BaseString showStringSQL rowStringSQLrowPlaceHolderStringSQLrowConsStringSQL listStringSQL $fShowExpr$fScalarDegreeMaybe intExprSQLescapeStringToSqlExpr stringExprSQL$fShowConstantTermsSQL(,)$fShowConstantTermsSQLMaybe Data.MaybeMaybe$fShowConstantTermsSQLLocalTime time-1.4.2Data.Time.LocalTime.LocalTime LocalTime$fShowConstantTermsSQLTimeOfDayData.Time.LocalTime.TimeOfDay TimeOfDay$fShowConstantTermsSQLDayData.Time.Calendar.DaysDay$fShowConstantTermsSQLDoubleghc-prim GHC.TypesDouble$fShowConstantTermsSQLFloatFloat$fShowConstantTermsSQLBoolBool$fShowConstantTermsSQLCharChar$fShowConstantTermsSQLText text-1.2.1.3Data.Text.Internal.LazyText$fShowConstantTermsSQLText0Data.Text.Internal $fShowConstantTermsSQLByteStringbytestring-0.10.4.0Data.ByteString.Lazy.Internal ByteString!$fShowConstantTermsSQLByteString0Data.ByteString.Internal$fShowConstantTermsSQL[]$fShowConstantTermsSQLIntInt$fShowConstantTermsSQLInt64GHC.IntInt64$fShowConstantTermsSQLInt32Int32$fShowConstantTermsSQLInt16Int16$fProductConstructor(->) intTermsSQLstringTermsSQL floatTermsconstantTimeTermsshowMaybeTermsunsafeCastExpr ColumnSQL'stringFromColumnSQLcomposeRestrict GroupingSetsCubeRollup ColumnRefshowsAggregateColumnRefcommaedpCommashowsAggregateBitKey$fShowColumnSQL'$fFunctorColumnSQL'transformers-0.3.0.0Control.Monad.Trans.ReaderReaderTNode ProductTreeNodeAttrnodeAttrnodeTreenode growRight growProductproductrestrictProduct'restrictProduct$fFoldableProductTreeJoinLeafJust'Pi'unsafeCastRecordWidthmap definePi'Database.Record.PersistablePersistableRecordWidthMapLeftestunsafePiAppend'unsafePiAppend unsafeCastsnd'' KeyConstraintunsafeReturnKey mapConstraint columnArrayfromTableToSQLfromTableToNormalizedSQL normalizedSQLtoSQLs showQualifier columnFromIdqualifiedSQLas qualifiedFormwidthOfProjectionUnitcolumnOfProjectionUnitcolumnOfUntypedProjectionshowsQueryProductshowsJoinProduct$fFunctorQualifiedFunctorScalar NormalizedColumnsBinBinOpSetOp IntersectExceptUnion showsSetOp' showsSetOpsetBinselectPrefixSQL showUnitSQLcolumnN asColumnNprojectionUnitFromColumns projectionUnitFromScalarSubQueryunitUntypedProjection JoinContextprimeJoinContextupdateProduct' updateProduct joinProductQualifyevalQualifyPrimenewAliasAliasIdunsafeFromColumns unsafeProjectSubListuntypeProjectiontypedProjectionnotNullMaybeConstraintinsertChunkSQLfmap compareBinOp monoBinOp monoBinOp'unsafeCastPlaceHolders$fProjectableApplicativePi$fProjectableFunctorPi"$fProjectableApplicativeProjection$fProjectableFunctorProjection$$fProjectableApplicativePlaceHolders $fProjectableFunctorPlaceHolders$fProjectableIdZipPlaceHolders$fProjectableMaybeExpr$fProjectableMaybeProjection$fProjectableMaybePlaceHolders$fProjectableShowSqlProjection$fProjectableShowSqlExpr$fSqlProjectableExpr$fSqlProjectableProjection$fSqlProjectableProjection0$fSqlProjectableProjection1OperatorProjectableunsafeFlatUniOp unsafeLikeunsafeCastProjectable whensClauseunsafeUniTermFunctionunsafeProjectPlaceHolder'unsafeProjectPlaceHolder$fOperatorProjectableExpr$fOperatorProjectableExpr0$fOperatorProjectableProjection $fOperatorProjectableProjection0 Projectable$fProjectableRunIdsZipaa$fProjectableRunIdsZip(,)b$fProjectableRunIdsZip(,)b0#$fProjectableFlattenMaybeMaybeMaybe$fProjectableFlattenMaybeMaybeb$fProjectableProjectionExpr!$fProjectableProjectionProjectionAggregatedContextproject projectPiprojectPiMaybeprojectPiMaybe'projectFlattenPiMaybe$fAggregatedContextOverWindow$fAggregatedContextAggregated$fMonadPartitionAggregatings$fMonadAggregateAggregatings$fMonadQueryAggregatings$fMonadRestrictcAggregatingsunsafeAggregateWithTermextractTermList finalizePowerProjectableOrderingupdateOrderBys$fProjectableOrderingProjection$fMonadPartitionOrderings$fMonadAggregateOrderings$fMonadQueryOrderings$fMonadRestrictrcOrderings orderTerms$fMonadRestrictcAssigningstargetProjectionupdateRestriction$fMonadAggregateRestrictings$fMonadQueryRestrictings$fMonadRestrictcRestrictingsControl.Monad.Trans.State.LazyStateT updateContextupdateJoinRestrictionunsafeSubQueryWithAttr$fMonadQueryQueryJoin$fMonadTransQueryJoin!$fMonadQualifyQualifyRestrictings$fMonadQualifyQualifyAssignings$fShowRestrictionrunRestriction_runUpdateTargetupdateAllColumn$fShowUpdateTarget$fMonadQualifyQualifyOrderingsaggregatedQuery$fMonadRestrictFlatRestrictings extractWindow queryUnique&$fMonadQualifyUniqueQualifyQueryUniquesubQueryQualifyFromRelation queryWithAttrjoin_uniqueQueryWithAttrplaceHoldersFromRelation queryList0 addUnitPHunsafeCastPlaceHolderunsafeLiftAppend liftAppend liftAppend'$fShowRelation $fShowDelete$fShowInsertQuery $fShowInsert $fShowUpdate$fShowKeyUpdate $fShowQuery targetTablerestrictedTable$fUntypeableNoFetchDelete$fUntypeableNoFetchUpdate$fUntypeableNoFetchInsertqueryA runQueryArunAofMunsafeQueryListunsafeQueryList'unsafeQueryScalarunsafeQueryScalar'defineHasConstraintKeyInstancecolumnTemplate'columnTemplatedefineTableDerivableInstancedefineTableDerivations'defineProductConstructorInstanceDefaultdefineWithPrimaryKeyDefaultdefineWithNotNullKeyDefaulttableSQLderivationVarNameDefaulttableVarNameDefaultrelationVarNameDefault