[sqlalchemy] Database agnostic datetime functions

2014-11-06 Thread Matthew Rocklin
What is the status of database agnostic datetime access functions like day of month or day or year? Are these implemented somewhere? If not are they planned? If not are they in scope? I'm specifically looking for a database-agnostic solution, not a solution for a particular database. Best,

Re: [sqlalchemy] Rearrange columns in SQLAlchemy core Select object

2014-09-22 Thread Matthew Rocklin
to make an example…. On Sep 19, 2014, at 9:50 AM, Matthew Rocklin mroc...@gmail.com javascript: wrote: Inner_columns ended up being the solution on stack-overflow. The current answer that provides this is somewhat convoluted though. If you wanted to say exactly what you just said on SO

Re: [sqlalchemy] Rearrange columns in SQLAlchemy core Select object

2014-09-22 Thread Matthew Rocklin
at the source. On Sep 22, 2014, at 1:26 PM, Matthew Rocklin mrock...@gmail.com wrote: Thanks for the response Michael. If you're interested, a follow-up question. http://stackoverflow.com/questions/25979620/sqlalchemy-join-expressions-without-nesting On Friday, September 19, 2014 10:21:05 AM UTC

Re: [sqlalchemy] Rearrange columns in SQLAlchemy core Select object

2014-09-22 Thread Matthew Rocklin
be making two “data criteria” objects of some kind that can be constructed into a statement later. that is, you need more abstraction here and you need to bind to the SQL expression system later. On Sep 22, 2014, at 1:32 PM, Matthew Rocklin mrock...@gmail.com wrote: My current solution

[sqlalchemy] Rearrange columns in SQLAlchemy core Select object

2014-09-19 Thread Matthew Rocklin
How can I reorder the columns in a SQLAlchemy query object without causing undue nesting? I've asked this question with an example on StackOverflow. Thought I'd advertise it here as well. Please let me know if this is not preferred.

[sqlalchemy] Specify Protected keywords in new SQL Dialect

2014-09-19 Thread Matthew Rocklin
When building a new SQL dialect how can one specify new protected keywords that should be quoted when generating SQL text queries? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it,

[sqlalchemy] Re: Specify Protected keywords in new SQL Dialect

2014-09-19 Thread Matthew Rocklin
Alternatively if someone can point me to the appropriate docs on this I'd be much obliged. A cursory view of the docs and Google didn't yield much. On Friday, September 19, 2014 6:32:26 AM UTC-4, Matthew Rocklin wrote: When building a new SQL dialect how can one specify new protected keywords

Re: [sqlalchemy] Rearrange columns in SQLAlchemy core Select object

2014-09-19 Thread Matthew Rocklin
the select.inner_columns accessor. On Sep 19, 2014, at 6:30 AM, Matthew Rocklin mrock...@gmail.com wrote: How can I reorder the columns in a SQLAlchemy query object without causing undue nesting? I've asked this question with an example on StackOverflow. Thought I'd advertise it here as well. Please