Raw

Should you need to, you can execute raw SQL.

>>> await Band.raw('select name from band')
[{'name': 'Pythonistas'}]

It’s recommended that you parameterise any values. Use curly braces {} as placeholders:

>>> await Band.raw('select * from band where name = {}', 'Pythonistas')
[{'name': 'Pythonistas', 'manager': 1, 'popularity': 1000, 'id': 1}]

Warning

Be careful to avoid SQL injection attacks. Don’t add any user submitted data into your SQL strings, unless it’s parameterised.