I might just be getting the syntax wrong but is the modulo (%) operator supported in the RSP ADQL via TAP.
I’m trying a query of the form,
select objectId from dp02_dc2_catalogs.Object where MOD(objectId,10)=0 limit 1000000
as MOD seems to be the ADQL operator but getting errors (I’ve also tried %)
DALQueryError: Query processing error: QI=?: Failed to instantiate query: ParseException:Failed to instantiate query: "SELECT objectId FROM dp02_dc2_catalogs.Object WHERE MOD(objectId,10)=0 LIMIT 1000000"