Naiyarah Hussain

@itsezc Thanks for raising this important issue and following up! Rate limiting and fine-grained permission control are important features for us at SurrealDB. On rate limiting, we're actively working on...

@leefordjudes @krikkiteer I'm happy to see this has now been fixed. You can try it out for yourself here on [Surrealist](https://surrealist.app/mini?query=INSERT+INTO+txns+%5B%0A++++++++%7B%0A++++++++++++date%3A+%222023-10-01%22%2C%0A++++++++++++voucher_no%3A+%22P1%22%2C%0A++++++++++++voucher_type%3A+%22purchase%22%2C%0A++++++++++++inventory%3A+%22inv1%22%2C%0A++++++++++++qty%3A+10%2C%0A++++++++++++pcost%3A+10%2C+%2F%2F+purchase+cost%0A++++++++++++srate%3A+10%2C+%2F%2F+sale+rate%0A++++++++++++amount%3A+100%0A++++++++%7D%2C%0A++++++++%7B%0A++++++++++++date%3A+%222023-10-01%22%2C%0A++++++++++++voucher_no%3A+%22S1%22%2C%0A++++++++++++voucher_type%3A+%22Sale%22%2C%0A++++++++++++inventory%3A+%22inv1%22%2C%0A++++++++++++qty%3A+-5%2C%0A++++++++++++pcost%3A+null%2C++++%2F%2F+purchase+may+be+null+or+None+on+sale%0A++++++++++++srate%3A+12%2C%0A++++++++++++amount%3A+60%0A++++++++%7D%2C%0A++++++++%7B%0A++++++++++++date%3A+%222023-10-01%22%2C%0A++++++++++++voucher_no%3A+%22S2%22%2C%0A++++++++++++voucher_type%3A+%22Sale%22%2C%0A++++++++++++inventory%3A+%22inv1%22%2C%0A++++++++++++qty%3A+-2%2C%0A++++++++++++srate%3A+12%2C%0A++++++++++++amount%3A+24%0A++++++++%7D%2C%0A++++++++%7B%0A++++++++++++date%3A+%222023-10-01%22%2C%0A++++++++++++voucher_no%3A+%22P2%22%2C%0A++++++++++++voucher_type%3A+%22purchase%22%2C%0A++++++++++++inventory%3A+%22inv1%22%2C%0A++++++++++++qty%3A+10%2C%0A++++++++++++pcost%3A+12%2C%0A++++++++++++srate%3A+15%2C%0A++++++++++++amount%3A+120%0A++++++++%7D%2C%0A++++++++%7B%0A++++++++++++date%3A+%222023-10-01%22%2C%0A++++++++++++voucher_no%3A+%22S3%22%2C%0A++++++++++++voucher_type%3A+%22Sale%22%2C%0A++++++++++++inventory%3A+%22inv1%22%2C%0A++++++++++++qty%3A+-5%2C%0A++++++++++++pcost%3A+null%2C%0A++++++++++++srate%3A+15%2C%0A++++++++++++amount%3A+75%0A++++++++%7D++++%0A%5D%3B%0A%0ASELECT+%0A++++inventory%2C+%0A++++math%3A%3Asum%28qty%29+AS+stock%2C+%0A++++math%3A%3Amean%28pcost%29+AS+avg_cost%2C%0A++++math%3A%3Asum%28pcost%29+AS+sum_cost++%0AFROM+txns+%0AGROUP+BY+inventory%3B)! Thanks once again for reporting this issues and helping...