As I don't have the needed 50 reputation I am just gonna leave a comment like this...
I have tried to use @EvanTrow code and it started to work after I made a small change (Oct. 2024):
// ❌ Does not work:
const {data, error} = await query();
// ✅ Works:
const {data, error} = await query;
I hope this small addition helps others in the future!