Using SQL page for my reporting on DuckDB

I would like to create compact graphs that show data series that have different scales of numbers on different axis.

What I would like is something like this on the data:

SELECT 'graph' as component, 'Small Number' AS ytitle, 'Large Numbers' AS ytitle2;
SELECT 'foo' AS series, 1 AS x, 10 as y, 1 as yaxis 
UNION ALL
SELECT 'foo' AS series, 1 AS x, 20 as y, 1 as yaxis 
UNION ALL
SELECT 'bar' AS series, 1 AS x, 100000 as y, 2 as yaxis 
UNION ALL
SELECT 'bar' AS series, 1 AS x, 200000 as y, 2 as yaxis 

What I would now expect to happen is that the right side of the plot contains a secondary y-axis with 'Large Numbers' as the title and where the series 'bar' is plotted on that axis and series 'foo' is plotted on the first axis (titled: 'small number')

It can be an error to plot the same series on different y-axis - though that does not really have to be the case (the other choice is equally valid)