NOT IN Query is not working i am getting exception

SELECT * AS parties valid_parties where party_id NOT IN (SELECT party_id FROM borrowing_entity)

{“timestamp”:“2023-11-23T05:15:09.452Z”,“thread”:“kalix-akka.actor.default-dispatcher-8”,“logger”:“kalix.javasdk.impl.DiscoveryImpl”,“message”:“Error reported from Kalix system: KLX-00106 Parse error for view query defined on au.com.westpac.blsop.domain.view.PartyIdViewService.GetAllEligiblePartyIds: Expected: from\n\nTo fix this issue, correct the query:\nSELECT * AS parties valid_parties where party_id NOT IN (SELECT party_id FROM borrowing_entity)\n ^\n\n\nAt security_guarantee/view/security_guarantee_view.proto:150:1:\nservice PartyIdViewService {\n option (kalix.codegen) = {\n view: {}\n };\n option (kalix.service).acl.allow = { service: "*" };\n”,“context”:“default”,“severity”:“ERROR”}

Is it missing FROM in SELECT * AS parties _FROM_ valid_parties ... perhaps?