.ai Isn't great about appending ALLOW FILTERING

[joaquincasares]

Given this table:

  CREATE TABLE IF NOT EXISTS super_awesome (
    attendee_id uuid PRIMARY KEY,
    full_name text,
    email text,
    country text,
    registration_date timestamp,
    ticket_type text,
    dietary_restrictions list<text>,
    session_interests set<text>
  );

AI sometimes provides me with ALLOW FILTERING, but not always:

>   .ai find VIP ticket holders

SELECT attendee_id, full_name, email, ticket_type FROM
conferences.super_awesome WHERE ticket_type = 'VIP' ALLOW FILTERING;

Also, some verbiage around ALLOW FILTERING being intensive could helpful.

[hshimizu]

I've updated the AI prompt to encourage this.

https://github.com/axonops/cqlai/actions/runs/18568112375