All of this over-engineering challenge is due to lacking of a good ORM model to deal with sql table/view, good cron job/webhook system to sync data in realtime/batching.

I would rather spend months to build a good platform rather than working on a over-complicated and low-level setup like this.