12 years agoorder by somewhat working
Matt S Trout [Thu, 11 Oct 2012 12:24:16 +0000]
order by somewhat working

12 years agoselect+join+where
Matt S Trout [Thu, 11 Oct 2012 12:07:51 +0000]
select+join+where

12 years agobeginnings of declarative code
Matt S Trout [Thu, 11 Oct 2012 12:01:12 +0000]
beginnings of declarative code

12 years agoSELECT a, b FROM foo
Prog Rammer [Fri, 7 Sep 2012 17:56:23 +0000]
SELECT a, b FROM foo

12 years agocosmetic
Prog Rammer [Mon, 27 Aug 2012 20:16:29 +0000]
cosmetic

12 years agotest for between
Prog Rammer [Mon, 27 Aug 2012 20:14:53 +0000]
test for between

12 years agotest for count(*)
Prog Rammer [Mon, 27 Aug 2012 18:29:25 +0000]
test for count(*)

12 years agoleft outer join
Prog Rammer [Mon, 27 Aug 2012 16:25:52 +0000]
left outer join

12 years agosimple group by test
Prog Rammer [Mon, 27 Aug 2012 16:18:37 +0000]
simple group by test

12 years agoanother way to join
Prog Rammer [Mon, 27 Aug 2012 16:08:47 +0000]
another way to join

from ilmari++ in irc

12 years agofixups for HAVING clauses
Matt S Trout [Sat, 25 Aug 2012 18:47:08 +0000]
fixups for HAVING clauses

12 years agowhitespace
Prog Rammer [Fri, 24 Aug 2012 20:09:18 +0000]
whitespace

12 years agolike sql.t but using ExprHelpers directly
Prog Rammer [Fri, 24 Aug 2012 20:00:38 +0000]
like sql.t but using ExprHelpers directly

Only a few features that I've figured out so far.

12 years agodon't deparenthesise subqueries with a group by
Matt S Trout [Thu, 23 Aug 2012 18:27:39 +0000]
don't deparenthesise subqueries with a group by

12 years agorandomised crazy order by support for subquery remap
Matt S Trout [Thu, 23 Aug 2012 18:27:21 +0000]
randomised crazy order by support for subquery remap

12 years agonuke old attempt at generic subquery
Matt S Trout [Thu, 23 Aug 2012 18:26:58 +0000]
nuke old attempt at generic subquery

12 years agoslightly better error messages
Matt S Trout [Thu, 23 Aug 2012 12:33:37 +0000]
slightly better error messages

12 years agofix desc detection for genericsubq
Matt S Trout [Sat, 18 Aug 2012 12:25:57 +0000]
fix desc detection for genericsubq

12 years agofirst cut at GenericSubquery
Matt S Trout [Fri, 17 Aug 2012 14:32:23 +0000]
first cut at GenericSubquery

12 years agoworking RowNum.pm
Matt S Trout [Fri, 17 Aug 2012 12:40:01 +0000]
working RowNum.pm

12 years agobeginnings of RowNum.pm
Matt S Trout [Thu, 16 Aug 2012 17:53:39 +0000]
beginnings of RowNum.pm

12 years agominor helper tweaks
Matt S Trout [Thu, 16 Aug 2012 17:34:23 +0000]
minor helper tweaks

12 years agoworking RowNumberOver
Matt S Trout [Thu, 16 Aug 2012 16:33:08 +0000]
working RowNumberOver

12 years agoRemove array expansion in Literal()
Matt Phillips [Fri, 17 Aug 2012 16:47:01 +0000]
Remove array expansion in Literal()

Was breaking SQL::Abstract testsuite.

12 years agofunctionalise order mapping
Matt S Trout [Sun, 29 Jul 2012 17:19:00 +0000]
functionalise order mapping

12 years agomore functional select list generation
Matt S Trout [Sun, 29 Jul 2012 15:20:05 +0000]
more functional select list generation

12 years agoslight syntactical cleanup
Matt S Trout [Sat, 28 Jul 2012 19:48:06 +0000]
slight syntactical cleanup

12 years agoadd compose routine and refactor FetchFirst to functional style
Matt S Trout [Sat, 28 Jul 2012 18:56:32 +0000]
add compose routine and refactor FetchFirst to functional style

12 years agoclean up FetchFirst more
Matt S Trout [Sat, 28 Jul 2012 18:06:58 +0000]
clean up FetchFirst more

12 years agoimport cleanups
Matt S Trout [Sat, 28 Jul 2012 17:57:48 +0000]
import cleanups

12 years agoremove debugging code
Matt S Trout [Sat, 28 Jul 2012 17:57:12 +0000]
remove debugging code

12 years agofirst expansion to using helper subs
Matt S Trout [Sat, 28 Jul 2012 17:48:52 +0000]
first expansion to using helper subs

12 years agofixup! first cut of rno sketch
Arthur Axel 'fREW' Schmidt [Sat, 28 Jul 2012 17:37:01 +0000]
fixup! first cut of rno sketch

12 years agofirst cut of rno sketch
Matt S Trout [Sat, 28 Jul 2012 16:52:56 +0000]
first cut of rno sketch

12 years agofix expr.include to generate alias nodes correctly
Matt S Trout [Sat, 28 Jul 2012 11:38:59 +0000]
fix expr.include to generate alias nodes correctly

12 years agofirst whack at GenericSubQ, half works
Matt S Trout [Sun, 27 May 2012 18:54:32 +0000]
first whack at GenericSubQ, half works

12 years agoMOAR order
Matt S Trout [Mon, 7 May 2012 06:16:12 +0000]
MOAR order

12 years agoFIRST ? SKIP ?
Matt S Trout [Sun, 6 May 2012 23:58:32 +0000]
FIRST ? SKIP ?

12 years agoimplement FIRST ? SKIP ?
Matt S Trout [Sun, 6 May 2012 23:25:01 +0000]
implement FIRST ? SKIP ?

12 years agofixup gensym behaviour
Matt S Trout [Fri, 20 Apr 2012 10:52:46 +0000]
fixup gensym behaviour

12 years agoORDER BY never generates ASC
Matt S Trout [Fri, 20 Apr 2012 10:52:37 +0000]
ORDER BY never generates ASC

12 years agoSlice implementations as roles
Matt S Trout [Fri, 20 Apr 2012 10:03:30 +0000]
Slice implementations as roles

12 years agoallow a group by node without a list
Matt S Trout [Fri, 20 Apr 2012 03:52:42 +0000]
allow a group by node without a list

12 years agohandle nested rather than unrolled joins
Matt S Trout [Mon, 16 Apr 2012 14:03:00 +0000]
handle nested rather than unrolled joins

12 years agoallow '' literals though wtf
Matt S Trout [Mon, 16 Apr 2012 13:46:25 +0000]
allow '' literals though wtf

12 years agorename alias node content
Matt S Trout [Mon, 16 Apr 2012 12:34:10 +0000]
rename alias node content

12 years agoslice type
Matt S Trout [Mon, 16 Apr 2012 07:11:08 +0000]
slice type

12 years agoON and LEFT/RIGHT
Matt S Trout [Sat, 14 Apr 2012 19:17:23 +0000]
ON and LEFT/RIGHT

12 years agoinitial group by support
Matt S Trout [Sat, 14 Apr 2012 17:10:39 +0000]
initial group by support

12 years agoalways_quote might be set with no quote chars
Matt S Trout [Sat, 14 Apr 2012 04:35:13 +0000]
always_quote might be set with no quote chars

12 years agolast direct hash access (I think)
Matt S Trout [Sat, 14 Apr 2012 02:54:44 +0000]
last direct hash access (I think)

12 years agoadd more attributes
Matt S Trout [Sat, 14 Apr 2012 02:54:16 +0000]
add more attributes

12 years agoinitial Mooification
Matt S Trout [Sat, 14 Apr 2012 02:48:51 +0000]
initial Mooification

12 years agofix test to pass, come back to it later
Matt S Trout [Sat, 14 Apr 2012 02:48:42 +0000]
fix test to pass, come back to it later

13 years agostart sketching out a Perl renderer
Matt S Trout [Sat, 13 Aug 2011 14:31:54 +0000]
start sketching out a Perl renderer

13 years agoclean up code to use intersperse
Matt S Trout [Sun, 31 Jul 2011 20:39:00 +0000]
clean up code to use intersperse

13 years agoINSERT support
Matt S Trout [Sun, 31 Jul 2011 19:39:06 +0000]
INSERT support

13 years agorefactor DELETE and add UPDATE
Matt S Trout [Sun, 31 Jul 2011 15:03:46 +0000]
refactor DELETE and add UPDATE

13 years agoDELETE support
Matt S Trout [Sun, 31 Jul 2011 10:01:32 +0000]
DELETE support

13 years agoadd constant for DQ_WHERE
Matt S Trout [Sun, 31 Jul 2011 09:11:55 +0000]
add constant for DQ_WHERE

13 years agoparens around BETWEEN
Matt S Trout [Sun, 31 Jul 2011 05:44:52 +0000]
parens around BETWEEN

13 years agogrudginly implement lc_keywords
Matt S Trout [Sun, 31 Jul 2011 05:38:30 +0000]
grudginly implement lc_keywords

13 years agoadd multipart literal support
Matt S Trout [Sun, 31 Jul 2011 01:20:46 +0000]
add multipart literal support

13 years agoallow a single literal arg to BETWEEN
Matt S Trout [Sun, 31 Jul 2011 00:59:37 +0000]
allow a single literal arg to BETWEEN

13 years agodisable quoting of function names in apply op
Matt S Trout [Sat, 30 Jul 2011 23:39:10 +0000]
disable quoting of function names in apply op

13 years agodefault to unop/binop based on args
Matt S Trout [Fri, 29 Jul 2011 19:59:02 +0000]
default to unop/binop based on args

13 years agoapply type op and NULL handling
Matt S Trout [Mon, 25 Jul 2011 15:04:45 +0000]
apply type op and NULL handling

13 years agoadd null, in, between etc. support
Matt S Trout [Mon, 25 Jul 2011 06:41:06 +0000]
add null, in, between etc. support

13 years agometadata for values, order by, values for literals
Matt S Trout [Sun, 17 Jul 2011 06:53:00 +0000]
metadata for values, order by, values for literals

13 years agosanify alias/SELECT list rendering
Matt S Trout [Sun, 17 Jul 2011 02:08:43 +0000]
sanify alias/SELECT list rendering

13 years agobeginnings of FROM, support for AS
Matt S Trout [Sun, 17 Jul 2011 00:41:01 +0000]
beginnings of FROM, support for AS

14 years agotest AS export
Matt S Trout [Sat, 16 Oct 2010 02:05:27 +0000]
test AS export

14 years agoclean up sql.t somewhat
Matt S Trout [Sat, 16 Oct 2010 01:54:30 +0000]
clean up sql.t somewhat

14 years agointroduce SELECT capability and skeleton test
Matt S Trout [Sat, 16 Oct 2010 01:51:57 +0000]
introduce SELECT capability and skeleton test

14 years agofactor construction of simple expressions out into ExprHelpers.pm
Matt S Trout [Sat, 16 Oct 2010 01:15:58 +0000]
factor construction of simple expressions out into ExprHelpers.pm

14 years agoswitch expr.t to factored out t/expr.include
Matt S Trout [Sat, 14 Aug 2010 21:02:53 +0000]
switch expr.t to factored out t/expr.include

14 years agobasic expression rendering for SQL::Naive
Matt S Trout [Sat, 14 Aug 2010 21:02:06 +0000]
basic expression rendering for SQL::Naive

14 years agochange perl to Perl
Matt S Trout [Sun, 6 Jun 2010 13:42:37 +0000]
change perl to Perl

14 years agounary operators
Matt S Trout [Sun, 6 Jun 2010 01:38:13 +0000]
unary operators

14 years agoadd & and | overloading to and and or
Matt S Trout [Sun, 6 Jun 2010 00:43:53 +0000]
add & and | overloading to and and or

14 years agofill out operator list and test not-currently-supported operators
Matt S Trout [Sat, 5 Jun 2010 18:12:39 +0000]
fill out operator list and test not-currently-supported operators

14 years agotest reversed operands
Matt S Trout [Sat, 5 Jun 2010 18:06:29 +0000]
test reversed operands

14 years agobasic binary operator code
Matt S Trout [Sat, 5 Jun 2010 18:05:50 +0000]
basic binary operator code

14 years agoidentifier expr builder
Matt S Trout [Sat, 5 Jun 2010 17:30:48 +0000]
identifier expr builder