Path: csiph.com!eternal-september.org!feeder.eternal-september.org!newsfeed1.swip.net!uio.no!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!newsgate.news.xs4all.nl!nzpost1.xs4all.net!not-for-mail Return-Path: X-Original-To: python-announce@python.org Delivered-To: python-announce-list@mail.python.org X-Spam-Status: OK 0.016 X-Spam-Evidence: '*H*': 0.97; '*S*': 0.00; 'url:pypi': 0.03; 'aggregate': 0.07; 'expressions': 0.07; 'subject:released': 0.07; 'literal': 0.09; 'subject:python': 0.14; 'boolean': 0.16; 'distinct': 0.16; 'pythonic': 0.16; 'received:eu': 0.16; 'simulate': 0.16; 'library': 0.20; 'select': 0.23; 'header:User- Agent:1': 0.26; "doesn't": 0.26; 'equivalent': 0.27; 'function': 0.28; "i'm": 0.30; 'announce': 0.32; 'url:python': 0.33; 'null': 0.33; 'add': 0.34; 'server': 0.34; 'received:google.com': 0.35; 'replace': 0.35; 'supports': 0.35; 'url:org': 0.36; 'received:209.85': 0.36; 'keyword': 0.36; 'missing': 0.37; 'release': 0.37; 'received:209': 0.38; 'received:209.85.220': 0.38; 'hi,': 0.38; 'subject:-': 0.39; 'url:0': 0.63; 'limit': 0.65; 'converter': 0.66; 'to:addr:comp-lang-python-announce': 0.68; 'upper': 0.76; 'to:addr:moderators.isc.org': 0.77; 'message- id:@googlegroups.com': 0.84 X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=path:newsgroups:date:complaints-to:injection-info:nntp-posting-host :user-agent:mime-version:message-id:subject:from:injection-date:to :content-type; bh=ZEOsHYgFfYXd3YO6Ta7OjsdY/9u8uLqEOsmNxGSDNIk=; b=GYKjRoni6SRMrHRmHjxaOqoU1pQVxsRQzvBTs7eRbXT/obTeH7Z6iSpIRK1GkvSVBb GQlf7tZ5IhMEMAMTpxgFwaiK4DutEg5IMSdI6o+uknFKjGKNXdzEjuF/iWkjbVsRNPae Venf3/rMlVBTff9gYDHltZ/a3RduS+OrvjIiEWiRdWjmwcbJDfqiu4J0v8PMvrgXORh4 NK3+fMY2M6A2NKDCwoQx/NA9wgUx1MjgdSmUqIvMAU2xhu6MJW5obXREr7jBp2RTDg3W MSuLYSTx9YVL33RP4uhLjjKg2c+QUu0L4l722xZyDZE+nrGKy6GY5zYpTNLeyWZ2gKnB XpxQ== X-Received: by 10.129.78.81 with SMTP id c78mr8707632ywb.19.1442669605369; Sat, 19 Sep 2015 06:33:25 -0700 (PDT) X-Received: by 10.50.30.102 with SMTP id r6mr31088igh.3.1442669605252; Sat, 19 Sep 2015 06:33:25 -0700 (PDT) Newsgroups: comp.lang.python.announce Date: Sat, 19 Sep 2015 06:33:24 -0700 (PDT) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=109.88.174.4; posting-account=KMnWFwoAAADKXBC7pUdLIrTFuYFBF3ZL User-Agent: G2/1.0 MIME-Version: 1.0 Subject: python-sql 0.8 released From: =?ISO-8859-1?Q?C=E9dric_Krier?= Injection-Date: Sat, 19 Sep 2015 13:33:25 +0000 To: comp-lang-python-announce@moderators.isc.org Content-Type: text/plain; charset=ISO-8859-1 X-Mailman-Approved-At: Sun, 20 Sep 2015 08:33:36 +0200 X-BeenThere: python-announce-list@python.org X-Mailman-Version: 2.1.20+ Precedence: list List-Id: Announcement-only list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Approved: python-announce-list@python.org Message-ID: Lines: 21 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1442730817 news.xs4all.nl 23858 [2001:888:2000:d::a6]:48717 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python.announce:1862 Hi, I'm glade to announce the new release of python-sql. python-sql is a library to write SQL queries in a pythonic way. In addition to bugfixes, this release contains those improvements: * Add no_as Flavor for server that doesn't support 'AS' keyword * Add rownum limit style * Add converter format2numeric to support library that supports only numeric parmstyle * Add no_boolean Flavor to replace boolean Literal by an equivalent expression * Add CURRENT_DATE function * Use UPPER to simulate missing ILIKE * Add NULL ordering * Allow to order on select queries * Add DISTINCT qualifier to aggregate expressions python-sql is available on PyPI: https://pypi.python.org/pypi/python-sql/0.8