Yv)J      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklm n o p q r s t u!v!w!x!y!z!{!|!}!~!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!""""""""""""""""""""""""""""(#2014 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownSafe!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 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;*Constraint which represents scalar degree. instance templates.2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownSafe#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 predicate Type tag for aggregated query (Type tag for flat (not-aggregated) query    2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9; %Interface for constant SQL term list.CSpecify tuple like record constructors which are allowed to define ProjectableFunctor.The constructor which has type r.!Constant integral SQL expression.Escape $ for constant SQL string expression.From % into constant SQL string expression.String interface of .$Constant SQL terms of '(a, b)' type.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 .Constant SQL terms of .Constant SQL terms of .Constant SQL terms of . Constant SQL terms of .!Constant SQL terms of ."Constant SQL terms of U. Use this carefully, because this is architecture dependent size of integer type.#Constant SQL terms of .$Constant SQL terms of .%Constant SQL terms of .&Constant SQL terms of .'$ProductConstructor instance of pair.#  !"#$%&'  !  !"#$%&'2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone:AT(Projection 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 >=>.0$Unsafely project untyped value list.*Unsafely define projection path from type r0 into type r1.1*Unsafely define projection path from type r0 into type r1. Use inferred .2*Unsafely define projection path from type r0 into type r1.3*Unsafely define projection path from type r0 into type r1. Use inferred .()*+,-./0Index of flat SQL value listResult projection path1Index of flat SQL value listResult projection path2Indexes of flat SQL value listResult projection path3Indexes of flat SQL value listResult projection path ()*+,-./0123 (*+,-./0123)()*+,-./0123-8.8/82013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone4Identity projection path.5!Projection path for fst of tuple.6!Projection path for snd of tuple.45Projection path of fst.6Projection path of snd. (*+-./456 (*+-./4564562013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<= 7 Constraint 9 inference interface.8Infer constraint key.9-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 9( proof object using specified key index.<Get table constraint  proof object from constraint 9.=1Get projection path proof object from constraint 9.6Unsafe. Make constraint key to add column phantom type*Map from table constraint into constraint 9.>Derive  constraint 9 from  constraint 9?Infered  constraint 9. Record type r has unique key which type is ct derived from primay key. 789:;-Key indexes which specify this constraint key"Result constraint key proof object<=>? 789:;<=>? 9:;<=>78? 789:;<=>?2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;,@Assignment pair list.AAssignment pairBValue SQL StringCColumn SQL StringDType for order-by termsEType for order-by termFType for order-by columnG)Order direction. Ascendant or Descendant.JTypeful aggregate element.KType for group-by treeLType for grouping setMType for group key.NType for group-by termO#Result record duplication attributeR$Unit of product is supported or not.UConfiguration type.\'Schema name qualify mode in SQL string.])Schema qualified table name in SQL string^&Not qualified table name in SQL string__/ type to customize names of expanded templates.cColumn SQL string typeSimple wrap typedc from stringec from String from ColumnSQLfStringSQL from ColumnSQLgDefault configuration.h%Compose duplication attribute string.i Single term aggregation element.jKey of aggregation power set.kSingle grouping set.lRollup aggregation element.mCube aggregation element.nGrouping sets aggregation.oEmpty aggregation.p0Compose GROUP BY clause from AggregateElem list.q9Compose PARTITION BY clause from AggregateColumnRef list.rExtract typed projection from J.sExtract untyped term from J.t5Unsafely bind typed-projection and untyped-term into J.u*Compose ORDER BY clause from OrderingTermsvCompose SET clause from @.wCompose VALUES clause from @.xCompose OVER (PARTITION BY ... ) clause.K@ABCDEFGHIJKL M NOPQRSTU VWXYZ[\]^_`abc defghijklmno pqrstuvwxyz{9@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwx9cdef_`ab\]^UVWXYZ[gRSTOPQhNMLKiojklmnpqJrstGHIFEDuCBA@vwx1@ABCDEFGHIJKL M NOPQRSTU VWXYZ[\]^_`abc defghijklmno pqrstuvwxyz{2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneInference rule of  existence.Phantom typed table typeUntyped 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 Untype table.Name string of table in SQL)Not qualified name string of table in SQLWidth of tableColumn name strings in SQL,Column name string in SQL specified by indexCast phantom type into  type.+Unsafely generate phantom typed table type. Column indexColumn name String in SQL Column indexColumn name String in SQL$2015 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneType for restriction of query.=Phantom typed projection. Projected into Haskell record type t.Discard projection value type Type for join product of query.Product node specialized by .Product tree specialized by ..Product node. node attribute and product tree.KProduct tree type. Product tree is constructed by left node and right node.node attribute for product.'Untyped projection. Forgot record type.Projection structure unitQualified query.Qualifier type.Sub-query typeSet binary operators Set operatorsUnsafely type projection value. instance of % !"#$%&'()*+,-./# !#"&$%'(+)*,-./ !"#$%&'()*+,-./%2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone0Get node attribute.1Get tree from node.27Make product node from node attribute and product tree.3&Push new tree into product right term.4+Push new leaf node into product right term.51Add restriction into top product of product tree.66Add restriction into top product of product tree node.012Node attribute Product tree Result node3 Current treeNew tree to push into right Result node4 Current treeNew leaf to push into right Result node5Product to restrictRestriction to addResult product6)Target node which has product to restrictRestriction to add Result node012460123456 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone( from .Unsafely generate flat  from untyped components.Unsafely generate aggregated  from untyped components.Union binary operator on Except binary operator on Intersect binary operator on  Width of .7SQL to query table.8*Generate normalized column SQL from table.9Normalized 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 qualifier;Alias string from qualifier<Binary operator to qualify.=9Qualified expression from qualifier and projection index.>From  SQL string into . Width of  SubQUery.Get column SQL string of .?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.AGet column of ProjectionUnit. Width of .BGet column SQL string of .)Get column SQL string list of projection.)Get column SQL string list of projection.Unsafely get SQL term from  Proejction.Unsafely generate  from SQL string list.C6Show product tree of query into SQL. StringSQL result.DShows join product of query.ECompose SQL String from .Compose WHERE clause from .Compose HAVING clause from .2FGTyped  metadataResult H789I:sub-query SQL and top-level SQLJKL;<=>?MNO@ABSource  Column indexResult SQL stringSource Result SQL string listSource Result SQL string list!SQL string list specifies columnsResult CDE""2FGH789I:JKL;<=>?MNO@ABCDE&2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneIP&Monad type to qualify SQL table forms.Q8Run qualify monad with initial state to get only result.R*Generated new qualifier on internal state.SLift to PTGet qualifyed table form query.PUVQRSTQuery to qualifyResult with updated statePQSTPUVQRST'2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneWJoinContext type for QueryJoin.XInitial W.YUpdate product of W.ZUpdate product of W.[6Finalize context to extract accumulated query product.W\]XYZ[WXZ[W\]XYZ[ 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneI^. type to require query generate configuration.Run  to expand with configurationLift to .Read configuration.__ 2015 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.`a `a 2013 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 . Unsafely get untyped projection.Unsafely generate # from qualified (joined) sub-query.Unsafely generate  from scalar sub-query.Unsafely generate unqualified  from .Unsafely generate  from SQL expression strings.bUnsafely trace projection path.&Trace projection path to get narrower .&Trace projection path to get narrower . From  type to  type.&Trace projection path to get narrower . 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  type.Projectable ap of  type.Make row list projection from  list.Make row list projection from .IMap projection show operatoions and concatinate to single SQL expression.cdSource Result SQL string listbSource Projection path Narrower Source .  typeProjection path Narrower .  type resultSource .  typeProjection path.  type leaf Narrower .  type resultefcdbef 2013 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.g"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 SQLgRecords 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 g2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;_*Weaken applicative functor on projections. Method like h.Weaken functor on projections. Method like i.)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.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.jMUnsafely make compare projection binary operator from string binary operator.kNUnsafely 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.lIUnsafely 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.0Operator corresponding SQL NOT (... IS NULL)$ , and extended against record type.1/Operator from maybe type using record extended isNull.2RANK() term.3 DENSE_RANK() term.4 ROW_NUMBER() term.5PERCENT_RANK() term.6 CUME_DIST() term.7.Unsafely add placeholder parameter to queries.8"Unsafely get placeholder parameter9No placeholder semanticsm)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 (6 which has record result type using applicative style.@ Compose seed of projection path ( which has record result type.ACompose record type  using applicative style.BCompose seed of record type .CCompose record type  using applicative style.DCompose seed of record type .ELZipping except for identity element laws against placeholder parameter type.FControl phantom  type in projection type .GControl phantom  type in placeholder parameters.HUnsafely get SQL term from  Proejction.KUnsafely make  from SQL terms.LUnsafely make  from SQL terms.MUnsafely make  from SQL terms.lnoSQL expression stringsResult projection objectSource projection objectResult SQL expression string.p jk    qlr !"#$%&'s Error tagEach when clausesElse result projectionResult projection(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./01t23456789muv:;<=>?@ABCDEFGHIJKLMP      !"#$%&'()*+,-./0123456789:;<=>P78:;9    .!"$#/01 %&'),(*+- 23456<=>cnop jk    qlr !"#$%&'s()*+,-./01t23456789muv:;<=>?@ABCDEFGHIJKLM44 4 4 4 444325544446677!6"6#7$7.4=12013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<=N3Interface to run recursively identity element laws.PInterface to compose phantom  nested type.R8Unsafely make aggregation uni-operator from SQL keyword.SAggregation function COUNT.TAggregation function SUM.UAggregation function SUM.VAggregation function AVG.WAggregation function AVG.XAggregation function MAX.YAggregation function MAX.ZAggregation 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.apGet narrower projection along with projection path and project into result projection type. Source record * phantom functor and projection path leaf  functor are join-ed.bYGet narrower projection with flatten leaf phantom Maybe types along with projection path.cYGet narrower projection with flatten leaf phantom Maybe types along with projection path.d Specialize O for  type.e>Base case definition to run recursively identity element laws.fRun right identity element law.gRun left identity element law.hNot  type is not processed.iCompose ! type in projection phantom type.NOPQwRSTUVWXYZ[\]^_Source projectionProjection pathNarrower projected object`Source .  typeProjection pathNarrower projected object.  type resultaSource .  phantom typeProjection path.  type leafNarrower projected object.  phantom type resultbSource .  phantom typeProjection path Narrower  . Flatten  phantom typecSource .  phantom typeProjection path&Narrower flatten and projected object.defghijkNOPQRSTUVWXYZ[\]^_`abcdPQb_`acRSUTWVYX[Z\]^NOdNOPQwRSTUVWXYZ[\]^_`abcdefghijk_8`8a8c82013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<=l(Window specification building interface.mAdd  PARTITION BY term into context.n,Aggregated query building interface extends s.oAdd GROUP BY1 term into context and get aggregated projection.q'Lift interface from base qualify monad.rLift from qualify monad q into s* m. Qualify monad qualifies table form SubQuery.sQuery building interface.tSpecify duplication.uAdd restriction to last join.v+Join sub-query with place-holder parameter p. query result is not .w+Join sub-query with place-holder parameter p. Query result is .xRestrict context interfacey Add restriction to this context.z'Specify ALL attribute to query context.{,Specify DISTINCT attribute to query context.|6Add restriction to last join. Projection type version.}-Add restriction to this not aggregated query.~MAdd restriction to this aggregated query. Aggregated Projection type version.lmnopqrstuvwxyz{|}~lmnopqrsvwtuxyz{|}~qrxystuvwnoplmz{|}~ lmnopqrstuvwxyz{|}~2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=I/Context monad type to build partition keys set..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.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.3Specify key of single grouping set from Projection.#Specify key of single grouping set.)Finalize and specify single grouping set.)Specify key of rollup and cube power set.0Finalize grouping power set as rollup power set..Finalize grouping power set as cube power set.Finalize grouping set list.Partition clause instanceAggregated query instance. Aggregated s. Aggregated q. Aggregated x.xyz{|xyz{|2013 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 D is ordering term.l with ordering.n with ordering.s with ordering.q with ordering.x 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 orderingDD}~2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=ITarget of assignment..Type to accumulate assigning context. Type r is table record type.Lift to Add an assignment.Add and assginment.Run  to get @q with assigning.x with assigning.  42015 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone6Target register monad type used from insert statement.Run InsertStatement.2013 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  Resticted n instance. Restricted s instance. Restricted q instance.x instance. 2013 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 .2013 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 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 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 s.Run  to get Joinable query instance. Attribute maybe or just to joinResult joined context and  result projection. 2013 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 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9:;<=-Partition monad type for partition-by clause.Aggregated query type.  p r ==  ( p,    r).Aggregated query monad type.Run  to get SQL with  computation.Run  to get  with  computation.?Operator to make window function result projection using built  monad. Restricted x instance.  to runResult SQL string with  computation to runResult  with  computation 82013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=$Simple (not-aggregated) query type.  SimpleQuery' p r ==  ( p,  r).)Simple (not-aggregated) query monad type.%Lift from qualified table forms into .Run  to get SQL string with Qualify computation.Run  to get  with Qualify computation. to runResult SQL string with Qualify computation SimpleQuery' to runResult  with Qualify computation2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone9;<=IUnique query monad type./Unsafely join sub-query with this unique query.Run  SimpleQuery to get  with Qualify computation.Attribute maybe or just to joinResult joined context and  result projection. to runResult  with Qualify computation2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone:-/Unique relation type to compose scalar queries.9Restriction function type for direct style join operator.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 s.!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.4  Left query to joinRight query to joinJoin restrictionsResult joined relation Left query to joinRight query to joinJoin restrictionsResult joined relation Left 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 relationLeft query to joinRight query to joinJoin restrictionsResult joined relation !"#$%&*      !"#$%&*  #$&%!"    3      !"#$%& 8 8 8 8888887777887777882013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone3'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.3(Update type with place-holder parameter p.6Update 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 :.AUnsafely make typed 6 from SQL string.B Make typed 6 from  and key columns selector (.C Make typed 6( object using derived info specified by  type.DUnsafely make typed 3 from SQL string.E$Make untyped update SQL string from  and .F Make typed 3 from U,  and .G Make typed 3 using g,  and .H Make typed 3 from U, derived table and I Make typed 3 from g, derived table and J Make typed 3 from  and !. Update target is all column.KDirectly make typed 3 from  and Restrict/ monad context. Update target is all column.LDirectly make typed 3 from  and Restrict/ monad context. Update target is all column.MStatement to use chunked insertNSize to use chunked insertOUnsafely make typed /+ from single insert and chunked insert SQL.PUnsafely make typed / from single insert SQL.Q Make typed / from  and columns selector ( with configuration parameter.R Make typed / from  and columns selector (.STable type inferred /.T Make typed / from U,  and monadic builded  object.U Make typed / from  and monadic builded  object.V Make typed / from U$, derived table and monadic builded  object.W Make typed / from g$, derived table and monadic builded  object.XUnsafely make typed , from SQL string.Y+Make untyped insert select SQL string from , ( and .Z Make typed , from columns selector , ( and  with configuration parameter.[ Make typed , from columns selector , ( and .\Table type inferred ,.]Unsafely make typed ) from SQL string.^$Make untyped delete SQL string from  and ._ Make typed ) from U,  and .` Make typed ) from  and .a Make typed ) from U, derived table and RestrictContextb Make typed ) from g, derived table and RestrictContextgShow delete SQL stringhShow insert SQL string.iShow insert SQL string.jShow update SQL stringkShow update SQL stringlShow query SQL stringH'()*+,-./0123456789:;<=Query SQL to type Typed result>?@ABCDEFGHIJKRestrict monad contextLMNOPQRSTUVWXYZ[\]^_`abcdefghijkl<'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`ab<:;<=?@>6789ABC345DFGHIJKLE/012MNOPQRSTUVW,-.XZ[\Y)*+]_`ab^'(9'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijkl 2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone:m$Query restricted with specified key.n+Query restricted with specified unique key.o,Query restricted with specified primary key.p+Query restricted with inferred primary key.qConvert 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.rTyped 6 using specified constraint key.sTyped 6 using inferred primary key.t inferred from table.m-Unique key proof object which record type is a and key type is p. to add restriction.Result restricted n-Unique key proof object which record type is a and key type is p. to add restriction.Result restricted o.Primary key proof object which record type is a and key type is p. to add restriction.Result restricted p to add restriction.Result restricted qr to updateKey with constraint c, record type r and columns type p Result typed Updates to update Result typed Updatet-Unique key proof object which record type is a and key type is p.Unique key value to specify.Result restricted mnopqrstmnoprsqtmnopqrst(2013 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNoneR (*+-./456789<=>?GHIRSTUVWXYZ[\]^_`abg      !"#$%&'()*+,-./0123456789:;<=>NOPQRSTUVWXYZ[\]^_`abcdlmnopqsvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<>?@BCEFGHIJKLMNOQRSTUVWYZ[\^_`abmnopqrst!2015 Kei HibinoBSD3ex8k.hibino@gmail.com experimentalunknownNone:I:uArrow type corresponding to )*vArrow type corresponding to )+wArrow type corresponding to xArrow type corresponding to yArrow type corresponding to zArrow type corresponding to {Arrow type corresponding to |Arrow type corresponding to }Arrow type corresponding to ~Arrow type corresponding to Arrow type corresponding to Arrow to build queries.Same as z. 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 vN. Arrow version. The result arrow is not injected by any local projections.Same as wN. 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 }f. Arrow version. The result arrow is designed to be injected by local conditional flat-projections.Same as ~l. Arrow version. The result arrow is designed to be injected by local conditional aggregated-projections.Same as oZ. 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 p4. This arrow is designed to be injected by local J.Same as E. This arrow is designed to be injected by local flat-projections.Same as 4. This arrow is designed to be injected by local  AggregteKey.Same as <. This arrow is designed to be injected by locally built  AggregtingSet arrow.Same as E. This arrow is designed to be injected by local flat-projections.Same as . Finalize locally built z.Same as . Finalize locally built z.Same as . Finalize locally built {.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 mF. The result arrow is designed to be injected by local projections.Same as 8. Make window function result projection using built x arrow.Make N into arrow which is designed to be injected by local projection assignees.Same as H . Make 34 from assigning statement arrow using configuration.Same as I . Make 3 from assigning statement arrow.Same as a . Make 33 from restrict statement arrow using configuration.Same as b . Make 3 from restrict statement arrow.Buvwxyz{|}~a (*+-./456789<=>?GHIRSTUVWXYZ[\]^_`abg      !"#$%&'()*+,-./0123456789:<=>NOPQRSTUVWXYZ[\]^_`abcdlnqsxy     $'()*+,-./0123456789:;<>?@BCEFGJKLMNOQRSTUVWYZ[\^_`mnopqrstuvwxyz{|}~:~}|{zyxwvuAuvwxyz{|}~8"2013-2016 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 primary key.$Rule template to infer not-null 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 H variable expression template from table name using default naming rule.Make template for  instance.Make template for record & instance using specified naming rule.LMake templates about table and column metadatas using specified naming rule.JMake templates about table and column metadatas using default naming rule.RMake templates about table, column and haskell record using specified 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 specified naming rule.<Generate all templtes about table using default naming rule.Unsafely inlining SQL string : in compile type.8Extract param type and result type from defined RelationInlining composed : 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 7 declaration Record typeKey typeIndexes specifies key"Result constraint key declarationsconfiguration parameters Schema name Table name Column typePrimary key index&Declarations of primary constraint key 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 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 ExpSchema 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 name*Column names and types and constraint typeResult declarations$Configuration to generate query with Schema name Table nameColumn names and typesRecord derivingsResult 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 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 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',-.,-/,-0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Z$$$$$$$$$$ Z     Z ^       X Y               !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~*+        !"#$%&'()*+,-./0123456789:;<=>??@AABCCDEFFGHHIJKKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{| } ~      !*!+!!!!!!!! !!!!!!!!!!!!!!!<!;!!!7!8!!!!!^! !!"!!!9!!!!!!!!!!!!! !!X!Y!q!r!!""""""""""""""""""""""""""""#######,VZ,-gxz{$$$$$$$$$$$$$$$$$$$$$:$9$$$$$ % % % % %%%      [            ! " # $ % & ' (&)&*&+&&&)&,'-'.'/'0'1'-'2345   6 7 8 9  : ;<=>?@ABCDEFGHIJKLMNOPQRSTUV3WXYZ[\]^._`abcdef!!g!h!i!j!k!l!m"n"o"p"q"r"s"t"u"v"w"xy/relational-query-0.8.2.2-GdSYWr6Ne3jA6kNqvMpgcy$Database.Relational.Query.Constraint Database.Relational.Query.Scalar!Database.Relational.Query.ContextDatabase.Relational.Query.Pure#Database.Relational.Query.Pi.UnsafeDatabase.Relational.Query.Pi#Database.Relational.Query.ComponentDatabase.Relational.Query.Table$Database.Relational.Query.ProjectionDatabase.Relational.Query.Sub,Database.Relational.Query.Monad.Trans.Config(Database.Relational.Query.Monad.BaseTypeDatabase.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.Assigning(Database.Relational.Query.Monad.Register1Database.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.RelationDatabase.Relational.Query.Type!Database.Relational.Query.DerivesDatabase.Relational.Query.ArrowDatabase.Relational.Query.TH&Database.Relational.Query.Internal.SQL&Database.Relational.Query.Internal.Sub*Database.Relational.Query.Internal.Product-Database.Relational.Query.Monad.Trans.Qualify/Database.Relational.Query.Monad.Trans.JoinStateDatabase.Relational.QueryMonadicRestrictedStatementAssignStatement0persistable-record-0.4.0.1-69n9mnU0q3AYFhSkFRU7pDatabase.Record.KeyConstraintUniqueNotNullPrimary ScalarDegreedefineScalarDegree$fScalarDegreeMaybePowerSetListSet OverWindowExists AggregatedFlatShowConstantTermsSQLshowConstantTermsSQL'ProductConstructorproductConstructorshowConstantTermsSQL$fShowConstantTermsSQL(,)$fShowConstantTermsSQLMaybe$fShowConstantTermsSQLUTCTime$fShowConstantTermsSQLZonedTime$fShowConstantTermsSQLLocalTime$fShowConstantTermsSQLTimeOfDay$fShowConstantTermsSQLDay$fShowConstantTermsSQLDouble$fShowConstantTermsSQLFloat$fShowConstantTermsSQLBool$fShowConstantTermsSQLChar$fShowConstantTermsSQLText$fShowConstantTermsSQLText0 $fShowConstantTermsSQLByteString!$fShowConstantTermsSQLByteString0$fShowConstantTermsSQL[]$fShowConstantTermsSQLInt$fShowConstantTermsSQLInt64$fShowConstantTermsSQLInt32$fShowConstantTermsSQLInt16$fShowConstantTermsSQLInt8$fProductConstructor(->)PiunsafeExpandIndexespfmappapwidth<.>pidefinePidefineDirectPi'defineDirectPiid'fst'snd'HasConstraintKey constraintKeyKeyindexesunsafeDefineConstraintKeytableConstraint projectionKey uniqueKeyderivedUniqueKey Assignments Assignment AssignTerm AssignColumn OrderingTerms OrderingTerm OrderColumnOrderAscDesc AggregateKey AggregateElem AggregateSetAggregateBitKeyAggregateColumnRef DuplicationAllDistinctProductUnitSupport PUSupportedPUNotSupportedConfigproductUnitSupportchunksInsertSizeschemaNameModenormalizedTableNameverboseAsCompilerWarning nameConfigSchemaNameModeSchemaQualifiedSchemaNotQualified NameConfig recordConfigrelationVarName ColumnSQL columnSQL columnSQL'showsColumnSQL defaultConfigshowsDuplicationaggregateColumnRefaggregatePowerKeyaggregateGroupingSetaggregateRollup aggregateCube aggregateSetsaggregateEmptycomposeGroupBycomposePartitionByaggregateKeyProjectionaggregateKeyElementunsafeAggregateKeycomposeOrderBy composeSets composeValues composeOver$fShowNameConfig$fShowColumnSQL'$fFunctorColumnSQL'$fEqSchemaNameMode$fShowSchemaNameMode$fShowProductUnitSupport $fShowConfig$fShowDuplication$fShowAggregateBitKey$fShowAggregateElem$fShowAggregateSet $fShowOrderTableDerivable derivedTableTableUntypedname'width'columns'!unTypename shortNamecolumnsindextoMaybetable $fShowUntyped Projection JoinProductQueryProductNode QueryProductUntypedProjectionProjectionUnit Qualified QualifierSubQuery fromTable flatSubQueryaggregatedSubQueryunionexcept intersectunitSQLshowSQLtoSQL qualifier unQualifyqualify queryWidthcolumnuntypedProjectionFromColumns#untypedProjectionFromScalarSubQuery#untypedProjectionFromJoinedSubQuerywidthOfUntypedProjectioncolumnsOfUntypedProjectionprojectionColumnsunsafeProjectionStringSqlunsafeProjectFromColumns composeWhere composeHaving QueryConfigrunQueryConfig queryConfigaskQueryConfig$fMonadQueryConfig$fFunctorQueryConfig$fApplicativeQueryConfigRelationConfigureQueryconfigureQuery qualifyQuery askConfigunsafeTypeRelationuntypeRelationrightPhleftPhsqlFromRelationWithsqlFromRelationdump$fShowRelationListProjectionunsafeStringSqluntypeunsafeFromQualifiedSubQueryunsafeFromScalarSubQueryunsafeFromTableunsafeFromSqlTermspiMaybepiMaybe' flattenMaybejustunsafeChangeContextunsafeToAggregated unsafeToFlatunsafeStringSqlNotNullMaybelistunsafeListFromSubQueryunsafeStringSqlList QuerySuffixshowsQuerySuffixupdatePrefixSQL updateSQL'updateOtherThanKeySQL'updateOtherThanKeySQLinsertPrefixSQLinsertSizedChunkSQL insertSQLdeletePrefixSQL'deletePrefixSQLProjectableApplicative|*|ProjectableFunctor|$|ProjectableIdZipleftIdrightIdProjectableMaybe PlaceHoldersSqlBinOpProjectableShowSqlunsafeShowSql'SqlProjectableunsafeProjectSqlTerms'unsafeProjectSqlTermsunsafeProjectSql'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><ipfmap$fProjectableApplicativePi$fProjectableFunctorPi"$fProjectableApplicativeProjection$fProjectableFunctorProjection$$fProjectableApplicativePlaceHolders $fProjectableFunctorPlaceHolders$fProjectableIdZipPlaceHolders$fProjectableMaybeProjection$fProjectableMaybePlaceHolders$fProjectableShowSqlProjection$fOperatorProjectableProjection $fOperatorProjectableProjection0$fSqlProjectableProjection$fSqlProjectableProjection0$fSqlProjectableProjection1ProjectableRunIdsZiprunIdsProjectableFlattenMaybeflattenunsafeAggregateOpcountsumMaybesum'avgMaybeavgmaxMaybemax'minMaybemin'everyany'some'?!?!?flattenPiMaybe!?? flattenPh$fProjectableRunIdsZipaa$fProjectableRunIdsZip(,)b$fProjectableRunIdsZip(,)b0#$fProjectableFlattenMaybeMaybeMaybe$fProjectableFlattenMaybeMaybeb$fAggregatedContextOverWindow$fAggregatedContextAggregatedMonadPartition partitionByMonadAggregategroupBygroupBy' MonadQualify liftQualify MonadQuerysetDuplication restrictJoinquery' queryMaybe' MonadRestrictrestrictall'distinctonwhereshaving$fMonadQualifyqqPartitioningSetAggregatingSetListAggregatingPowerSetAggregatingSetPartitioningSetTAggregatingPowerSetTAggregatingSetListTAggregatingSetT Aggregatings aggregatingsextractAggregateTermskeykey'setbkeyrollupcube groupingSets$fMonadPartitioncAggregatings$fMonadAggregateAggregatings$fMonadQueryAggregatings$fMonadQualifyqAggregatings$fMonadRestrictcAggregatings$fMonadTransAggregatings$fMonadAggregatings$fFunctorAggregatings$fApplicativeAggregatings Orderings orderingsorderByascdescextractOrderingTerms$fProjectableOrderingProjection$fMonadPartitioncOrderings$fMonadAggregateOrderings$fMonadQueryOrderings$fMonadQualifyqOrderings$fMonadRestrictrcOrderings$fMonadTransOrderings$fMonadOrderings$fFunctorOrderings$fApplicativeOrderings AssignTarget Assignings assigningsassignTo<-#extractAssignments$fMonadQualifyqAssignings$fMonadRestrictcAssignings$fMonadTransAssignings$fMonadAssignings$fFunctorAssignings$fApplicativeAssigningsRegisterextract 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$fFunctorQueryUniqueUniqueRelationJoinRestrictionderivedRelationtableOfquery 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%defineHasPrimaryKeyInstanceWithConfig"defineHasPrimaryKeyInstanceDefaultdefineHasNotNullKeyInstance%defineHasNotNullKeyInstanceWithConfig"defineHasNotNullKeyInstanceDefault defineColumnsdefineColumnsDefaultdefineTableTypesderivationExpDefaulttableVarExpDefaultrelationVarExprelationVarExpDefault defineProductConstructorInstancedefineTableTypesWithConfigdefineTableTypesDefaultdefineTableTypesAndRecord defineTableTypesAndRecordDefaultdefinePrimaryQuerydefinePrimaryUpdatedefineSqlsWithPrimaryKeydefineSqlsWithPrimaryKeyDefault defineTabledefineTableDefaultunsafeInlineQuery reifyRelation inlineQuerymakeRelationalRecordDefault StringSQL stringSQLbaseGHC.BaseString showStringSQL rowStringSQLrowPlaceHolderStringSQLrowConsStringSQL listStringSQL intExprSQLescapeStringToSqlExpr stringExprSQLMaybe 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.IntInt64Int32Int16Int8 intTermsSQLstringTermsSQL floatTermsconstantTimeTermsshowMaybeTermsPi'unsafeCastRecordWidthmap definePi'Database.Record.PersistablePersistableRecordWidthLeftestMapunsafePiAppend'unsafePiAppend unsafeCastsnd'' KeyConstraintunsafeReturnKey mapConstraint ColumnSQL'stringFromColumnSQL ColumnRefRollupCube GroupingSetsshowsAggregateColumnRefcommaedpCommashowsAggregateBitKey columnArrayQueryRestrictionuntypeProjectionNode ProductTreeNodeAttrBinOpSetOptypedProjection$fFunctorQualifiedFunctorLeafJoinJust'Columns NormalizedScalarBinUnionExcept IntersectnodeAttrnodeTreenode growRight growProductrestrictProduct'restrictProductfromTableToSQLfromTableToNormalizedSQL normalizedSQLtoSQLs showQualifier columnFromIdqualifiedSQLas qualifiedFormwidthOfProjectionUnitcolumnOfProjectionUnitcolumnOfUntypedProjectionshowsQueryProductshowsJoinProductcomposeRestrict showsSetOp' showsSetOpsetBinselectPrefixSQL showUnitSQLcolumnN asColumnNprojectionUnitFromColumns projectionUnitFromScalarSubQueryunitUntypedProjectionQualifyevalQualifyPrimenewAliasAliasId JoinContextprimeJoinContextupdateProduct' updateProduct joinProductproducttransformers-0.5.2.0Control.Monad.Trans.ReaderReaderTunsafeCastPlaceHolder unsafeProjectListSubnotNullMaybeConstraintinsertChunkSQL<*>fmap compareBinOp monoBinOp monoBinOp'unsafeCastPlaceHoldersOperatorProjectableunsafeFlatUniOp unsafeLikeunsafeCastProjectable whensClauseunsafeUniTermFunctionunsafeProjectPlaceHolder'unsafeProjectPlaceHolderAggregatedContextunsafeAggregateWithTerm aggregateKeyextractTermList finalizePowerProjectableOrderingupdateOrderBys orderTermstargetProjectionupdateRestrictionrunRestriction_runUpdateTargetupdateAllColumnControl.Monad.Trans.State.LazyStateT updateContextupdateJoinRestriction queryWithAttr extractWindowjoin_uniqueQueryWithAttrplaceHoldersFromRelation queryList0 addUnitPHunsafeLiftAppend liftAppend liftAppend' targetTablerestrictedTablequeryA runQueryArunAofMunsafeQueryListunsafeQueryList'unsafeQueryScalarunsafeQueryScalar'defineHasConstraintKeyInstancecolumnTemplate'columnTemplatedefineTableDerivableInstancedefineTableDerivations*defineProductConstructorInstanceWithConfigdefineWithPrimaryKeydefineWithNotNullKeyWithConfigtableSQLderivationVarNameDefaulttableVarNameDefault