https://blog.alldonetechnology.com/index.php/2020/08/29/how-to-use-custom-query-mysql-in-magento2/