it doesn’t seem right to me to have a new table which mostly reports existing information reaching out to a remote API on every table scan to query a set of conditions that could perhaps be better and more sustainably distributed as a set of static rules