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
Matt S Trout [Mon, 7 May 2012 06:16:12 +0000]
MOAR order
Matt S Trout [Sun, 6 May 2012 23:58:32 +0000]
FIRST ? SKIP ?
Matt S Trout [Sun, 6 May 2012 23:25:01 +0000]
implement FIRST ? SKIP ?
Matt S Trout [Fri, 20 Apr 2012 10:52:46 +0000]
fixup gensym behaviour
Matt S Trout [Fri, 20 Apr 2012 10:52:37 +0000]
ORDER BY never generates ASC
Matt S Trout [Fri, 20 Apr 2012 10:03:30 +0000]
Slice implementations as roles
Matt S Trout [Fri, 20 Apr 2012 03:52:42 +0000]
allow a group by node without a list
Matt S Trout [Mon, 16 Apr 2012 14:03:00 +0000]
handle nested rather than unrolled joins
Matt S Trout [Mon, 16 Apr 2012 13:46:25 +0000]
allow '' literals though wtf
Matt S Trout [Mon, 16 Apr 2012 12:34:10 +0000]
rename alias node content
Matt S Trout [Mon, 16 Apr 2012 07:11:08 +0000]
slice type
Matt S Trout [Sat, 14 Apr 2012 19:17:23 +0000]
ON and LEFT/RIGHT
Matt S Trout [Sat, 14 Apr 2012 17:10:39 +0000]
initial group by support
Matt S Trout [Sat, 14 Apr 2012 04:35:13 +0000]
always_quote might be set with no quote chars
Matt S Trout [Sat, 14 Apr 2012 02:54:44 +0000]
last direct hash access (I think)
Matt S Trout [Sat, 14 Apr 2012 02:54:16 +0000]
add more attributes
Matt S Trout [Sat, 14 Apr 2012 02:48:51 +0000]
initial Mooification
Matt S Trout [Sat, 14 Apr 2012 02:48:42 +0000]
fix test to pass, come back to it later
Matt S Trout [Sat, 13 Aug 2011 14:31:54 +0000]
start sketching out a Perl renderer
Matt S Trout [Sun, 31 Jul 2011 20:39:00 +0000]
clean up code to use intersperse
Matt S Trout [Sun, 31 Jul 2011 19:39:06 +0000]
INSERT support
Matt S Trout [Sun, 31 Jul 2011 15:03:46 +0000]
refactor DELETE and add UPDATE
Matt S Trout [Sun, 31 Jul 2011 10:01:32 +0000]
DELETE support
Matt S Trout [Sun, 31 Jul 2011 09:11:55 +0000]
add constant for DQ_WHERE
Matt S Trout [Sun, 31 Jul 2011 05:44:52 +0000]
parens around BETWEEN
Matt S Trout [Sun, 31 Jul 2011 05:38:30 +0000]
grudginly implement lc_keywords
Matt S Trout [Sun, 31 Jul 2011 01:20:46 +0000]
add multipart literal support
Matt S Trout [Sun, 31 Jul 2011 00:59:37 +0000]
allow a single literal arg to BETWEEN
Matt S Trout [Sat, 30 Jul 2011 23:39:10 +0000]
disable quoting of function names in apply op
Matt S Trout [Fri, 29 Jul 2011 19:59:02 +0000]
default to unop/binop based on args
Matt S Trout [Mon, 25 Jul 2011 15:04:45 +0000]
apply type op and NULL handling
Matt S Trout [Mon, 25 Jul 2011 06:41:06 +0000]
add null, in, between etc. support
Matt S Trout [Sun, 17 Jul 2011 06:53:00 +0000]
metadata for values, order by, values for literals
Matt S Trout [Sun, 17 Jul 2011 02:08:43 +0000]
sanify alias/SELECT list rendering
Matt S Trout [Sun, 17 Jul 2011 00:41:01 +0000]
beginnings of FROM, support for AS
Matt S Trout [Sat, 16 Oct 2010 02:05:27 +0000]
test AS export
Matt S Trout [Sat, 16 Oct 2010 01:54:30 +0000]
clean up sql.t somewhat
Matt S Trout [Sat, 16 Oct 2010 01:51:57 +0000]
introduce SELECT capability and skeleton test
Matt S Trout [Sat, 16 Oct 2010 01:15:58 +0000]
factor construction of simple expressions out into ExprHelpers.pm
Matt S Trout [Sat, 14 Aug 2010 21:02:53 +0000]
switch expr.t to factored out t/expr.include
Matt S Trout [Sat, 14 Aug 2010 21:02:06 +0000]
basic expression rendering for SQL::Naive
Matt S Trout [Sun, 6 Jun 2010 13:42:37 +0000]
change perl to Perl
Matt S Trout [Sun, 6 Jun 2010 01:38:13 +0000]
unary operators
Matt S Trout [Sun, 6 Jun 2010 00:43:53 +0000]
add & and | overloading to and and or
Matt S Trout [Sat, 5 Jun 2010 18:12:39 +0000]
fill out operator list and test not-currently-supported operators
Matt S Trout [Sat, 5 Jun 2010 18:06:29 +0000]
test reversed operands
Matt S Trout [Sat, 5 Jun 2010 18:05:50 +0000]
basic binary operator code
Matt S Trout [Sat, 5 Jun 2010 17:30:48 +0000]
identifier expr builder