prepare v3

[Slach]

Todo task

Bugs

• [x] turn off skip_comments wrong pass to server, details https://github.com/Altinity/clickhouse-grafana/pull/491#issuecomment-1892700797

Frontend

• [x] Query Editor

  • [x] add the same forms and logic as angular plugin for "Query options" and "SQL Editor" modes
  • [x] graph panels shall show data from clickhouse responses
  • [x] adhoc connected properly in datasource.ts
  • [x] $__searchFilter to template variable queries
  • [x] ci unittest passed

• [x] SQLEditor

  • [x] Syntax highlight
  • green color palette instead of blue
  • $macros
  • function
  • keywords
  • [x] suggestions auto-complete
  • [x] height auto-expand
  • [x] scrolling properly works after expand
  • [x] accumulate changes 2 seconds before execution query or execute query only onBlur instead of onChange

Backend

• [x] query implementation
• [x] evalQuery implementation
• [x] test passed
• [x] X-ClickHouse-Key authorization works
• [x] graphPanel alerts works
• [x] unified alers works

Can't implements without changing grafana core

• [ ] template variable editor
  • [ ] syntax highlight
  • [ ] auto-complete
• [ ] annotations editor
  • [ ] syntax highlight
  • [ ] auto-complete

[Slach]

@lunaticusgreen i found one more bug

turn off skip_comments dashboard doesn't work looks like comments properly pass to Show Generated SQL but miss new lines during pass to server

[Slach]

all works good, only x-auth need a workaround, will merge and wait https://github.com/grafana/grafana/pull/80858