It would be very helpful to enable SQL for charts. While filtering by Selection and Extent can work for a temporary filter, having SQL for just the chart while maintaining all data on the layer can be advantageous for visualizing geographic data in the layer separately from the chart.