[issue14619] Enhanced variable substitution for databases

[Raymond Hettinger]

New submission from Raymond Hettinger <raymond.hettinger at gmail.com>:

I suggest adding a ?? placeholder for variable length substitutions in SQL statements:

vars = 'Knight', ('Gwain', 'Gallahad', 'Lancelot'), 30
c.execute('''SELECT * FROM loyalsubjects
             WHERE rank = ? 
             AND name IN (??)
             AND age >= ?
          ''', vars)

----------
components: Extension Modules
messages: 158698
nosy: rhettinger
priority: low
severity: normal
status: open
title: Enhanced variable substitution for databases
type: enhancement
versions: Python 3.4

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue14619>
_______________________________________