it can be exceedingly handy to update things like daily conversion tables or grab output from an ETL job that has been exposed by an API. Construct your SQL we

it can be exceedingly handy to update things like daily conversion tables or grab output from an ETL job that has been exposed by an API. Construct your SQL well with proper TX isolation and guards and there's no worry, and it's much better in many cases where data warehouses are employed than writing extra software on top.