Integrate Erp and Metabase

Dear Experts ,
I have integrated metabase in my erpnext. However it supports only a basic query. Is there a way I can integrate standard reports build with python like balance sheet in metabase.

I would be interested to see your integration. Can you post some screenshots or videos?

So do I need the steps please.You cannot use H2 in production.I have spent days in this without successfully joining the database that has my Erpnext.Note I was able to create another database and successfully joined it.
Desire to see your detail steps.Thanks