> I think 1 write to 10 reads is still write-heavy.

Pretty easy to tune the suppled SQL query to suit your opinion.

Pretty sure you just need to tweak the 2nd line

ratio_target AS (SELECT 5 AS ratio),