InfluxDB: Add new truthiness operators (Is and Is Not) to InfluxQL Query Builder

[btasker]

What is this feature?

Implements support for including query conditions based upon boolean field values using new Is and Is Not operators (see note below) (#77794).

Why do we need this feature?

There's a pre-existing issue where it's not possible because after submission, the value will be coerced to a string (e.g. false will be coerced to 'false').

Who is this feature for?

Users who want to use the InfluxQL Query Builder to build WHERE conditions based on Boolean fields

Which issue(s) does this PR fix?:

Fixes #77794

Special notes for your reviewer:

Please check that:

• It works as expected from a user's perspective.
• If this is a pre-GA feature, it is behind a feature toggle.
• The docs are updated, and if this is a notable improvement, it's added to our What's New doc.

[btasker]

@itsmylife - this should be ready for review.

The latest 3 commits add type inference so that Is and Is Not work with string/int/float fields (if the key indicates a tag the value will always be quoted). If needed, they can safely be dropped/reverted out of the PR before merge so that it simply adds Is and Is Not.

The front-end code has also been updated so that correct translation occurs when the user switches between builder and raw mode (I didn't think to check that on the previous PR)

[itsmylife]

That looks good! ❤️
Could you please provide tests for influx_query_model too?
Thanks in advance!

[btasker]

👍 done!

[btasker]

@itsmylife FYI, that pending check just shows "Build is blocked, please, contact repo admin in order to proceed" (same on the other PR too).

[itsmylife]

@btasker I will enable it when we'll fix the problem in our CI pipeline. There is an unrelated thing broken right now.

[btasker]

👍 Thanks - was just double checking I hadn't broken anything :)

[itsmylife]

@btasker I merged the other PR and we got conflicts with this one. Could you please resolve them? I tried on github UI and failed :) And I don't want to mess your PR up.

[itsmylife]

LGTM it just needs the conflicts to resolve

[btasker]

👍 Sure will look at these a little later (I had a feeling we might get some)

[btasker]

Github's UI was failing me too, so I've rebased on main and resolved the conflicts

[itsmylife]

@btasker now there is a linting issue. But we are quite close to merge it :)

+ yarn run prettier:check
[warn] public/app/plugins/datasource/influxdb/components/editor/query/influxql/visual/TagsSection.tsx
[warn] public/app/plugins/datasource/influxdb/influx_query_model.test.ts
[warn] public/app/plugins/datasource/influxdb/influx_query_model.ts
[warn] Code style issues found in 3 files. Run Prettier to fix.

[btasker]

Got it - looks like I accidentally introduced some additional whitespace whilst rebasing (lint-prettier doesn't get called during that process because there's no commit to trigger the hooks)