https://www.growthbook.io/ logo
#give-feedback
Title
# give-feedback
n

narrow-psychiatrist-15437

03/18/2022, 11:32 AM
I've found a bug in Metrics: If I try to edit the query in Query Settings, which is made using the query builder, and hit "Save", my query is replaced by the auto-generated SQL query. I then have to edit the metric again and specifically select the query builder. Also, the "User Type Supported" seems to reset when this happens. I would assume the SQL query should be identical to the query I built with the query builder? See the attached the recording for an example.
f

future-teacher-7046

03/18/2022, 4:41 PM
Ah, I think I know what's going on. The SQL input is getting auto-populated with a default value and that takes precedence over the query builder settings.
We were considering deprecating the query builder entirely in favor of just the SQL input. I'm curious to know what things you prefer about that input method.
n

narrow-psychiatrist-15437

03/21/2022, 1:24 PM
Ahh, that makes sense. Raw SQL would work well also, but it would be nice to have syntax highlighting and auto-completion rather than a vanilla
textarea
input field.
I'd have a look at dune.xyz's SQL editor for inspiration
15 Views