Hey @produccion,
What do you mean by “Bubble DB doesn’t support queries”?
In your case, I suggest you use two custom states (current year and current month) that you can update when the dropdown values change.
You can set a default value for them and build your charts relative to these both states