11 years agoAdd OffsetFetchNext limit dialect sql-server-2012
Arthur Axel 'fREW' Schmidt [Tue, 29 May 2012 02:19:20 +0000]
Add OffsetFetchNext limit dialect

This dialect supports SQL Server 2012.  It renders like this:

 SELECT me.id, me.source, me.owner, me.price, owner.id, owner.name
   FROM books me
   JOIN owners owner ON owner.id = me.owner
   WHERE ( source = ? )
   ORDER BY me.id
   OFFSET ? ROWS
   FETCH NEXT ? ROWS ONLY

http://msdn.microsoft.com/en-us/library/gg699618%28v=SQL.110%29.aspx

Note that it REQUIRES an ORDER BY clause

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

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

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

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

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

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

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

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

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

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

12 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

12 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

12 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

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

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

12 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

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

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

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

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

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

13 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

13 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

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

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

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

13 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

13 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

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

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

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