query_raw and execute_raw

[skbom]

I'd like to write a write a query bit execute_raw returns an int and query_raw does not seem to accept placeholders. how do I do it?

This returns an int
total = await db.execute_raw( ''' SELECT * FROM User WHERE User.id = ? ''', 'cksca3xm80035f08zjonuubik' )

And I don't know how to safly query, i.e with placeholders with this. Giving the User.id as an extra argument doesn't work
posts = await db.query_raw( ''' SELECT * FROM User WHERE User.id = ? ''' )

[RobertCraigie]

What issue did you run into when passing the extra argument to query_raw?

[skbom]

query = "select * from assets limit ?;"
assets = db.query_raw(query, 10)
print(assets)

Gives:
prisma.errors.RawQueryError: ERROR: syntax error at or near ";"

Hi Roberts, thank you for the quick response :)
See mabove, I have also tried to pass the 10 as a string.

[RobertCraigie]

@skbom try removing the ;

[skbom]

@RobertCraigie without the ; I'm getting the following error:
prisma.errors.RawQueryError: ERROR: syntax error at end of input

[timmedia]

For anyone landing on this page while debugging: for me this issue was solved by replacing '?' with '$1', as explained in this comment on issue #673.