Any plans to support SQL prepared statements?

[vlanse]

https://dev.mysql.com/doc/refman/5.6/en/sql-syntax-prepared-statements.html

Do you have any plans to support this? Could be useful to utilise MySQL server more efficient, e.g. do not parse SQL on server any time the same query with different parameters appears.

[jettify]

I think they should work in same way as stored procedure work:

aiomysql/examples/example_callproc.py

Lines 5 to 22 in 274cfc0

	async def test_example(loop):
	conn = await aiomysql.connect(host='127.0.0.1', port=3306,
	user='root', password='',
	db='test_pymysql', loop=loop)
	async with conn.cursor() as cur:
	await cur.execute('DROP PROCEDURE IF EXISTS myinc;')
	await cur.execute("""CREATE PROCEDURE myinc(p1 INT)
	BEGIN
	SELECT p1 + 1;
	END""")
	await cur.callproc('myinc', [1])
	(ret, ) = await cur.fetchone()
	assert 2, ret
	print(ret)
	conn.close()

[vlanse]

@jettify sorry, just a little more context. I meant especially sqlalchemy case (e.g. when using sa connection)
right now the execute code always substitutes values on client side

[jettify]

Does sqlalchemy support prepared statements?

[vlanse]

Well, looks like it's not about sqlalchemy which is responsible for building the queries. The sa compiled statement itself could be handled by connector in a special way - like "prepared" statement.

[Nothing4You]

considering that this library is based on PyMySQL this should be implemented in PyMySQL first and only then ported to aiomysql.

see PyMySQL/PyMySQL#202