Is there a way to implement BQL using python API or even any language`s API?
You should ask for access to BQNT. There is currently no publicly available interface to the BQL Excel formula from any programming language.