Can't get translated report

hi all ,
I had created a custom query report , and there is some output that I need translated into another language .
the output not changed based on language that I used .

I need to find a way to translate the query response based on user default language.

@Rashed_Omar you have to put the text in translate function like this:


inside the sql query !

no, you should do it after getting the data from the query.
but you have to import the function like this:

from frappe import _