did you check dbxlookup? I don't think you can construct the query as you shared but you can still make use of that to get your results. you want to do lookup using multi values fields using or condition, that's not possible. But, you can perform "AND" not "OR" condtion. | your query // don't apply stats to get multi value field.
| dbxlookup connection="connection_name" query="SELECT * FROM \"schemaname\".\"tablename\"" "Category" AS "Category", "Items" AS "Iteams" OUTPUT "specify fields you want to get" https://docs.splunk.com/Documentation/DBX/3.4.0/DeployDBX/Createandmanagedatabaselookups#Create_a_database_lookup
... View more