Does it work if you check "Disable converting queries to prepared statements" in the resource settings? I think it might be a prepared statement issue since the column ID is dynamic
More documentation on this: Read data from SQL databases | Retool Docs