From 66b7d008ee2975744212fc1b3831375b15db055f Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Sat, 21 Nov 2009 20:51:16 +0000
Subject: [PATCH] add an interesting from_statement() format

---
 doc/build/ormtutorial.rst | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/doc/build/ormtutorial.rst b/doc/build/ormtutorial.rst
index b1f647e51b..d23834c0db 100644
--- a/doc/build/ormtutorial.rst
+++ b/doc/build/ormtutorial.rst
@@ -581,6 +581,15 @@ To use an entirely string-based statement, using ``from_statement()``; just ensu
     ['ed']
     {stop}[<User('ed','Ed Jones', 'f8s7ccs')>]
 
+You can use ``from_statement()`` to go completely "raw", using string names to identify desired columns:
+
+.. sourcecode:: python+sql
+
+    {sql}>>> session.query("id", "name", "thenumber12").from_statement("SELECT id, name, 12 as thenumber12 FROM users where name=:name").params(name='ed').all()
+    SELECT id, name, 12 as thenumber12 FROM users where name=?
+    ['ed']
+    {stop}[(1, u'ed', 12)]
+
 Counting
 --------
 
-- 
2.47.3