@BARADZA Jonathan , thank you for reaching out to us. I could not understand the architecture as available in the screenshot above. Can you please review the following image and queries and confirm if this is how it works:-
1. I am assuming that the Http request from scanning the QR code launches a browser which takes you to the Static Web App (SWA) which in turn calls the Azure Function as an API (which queries Azure SQL DB) and returns result back to SWA. The returned result is displayed in the SWA. Please correct me if I missed something.
2. Regarding "...data from SQL DB send them to the azure static page as parameters but not as url query parameters which is the current setup". Can you share more details about it? Please refer to this link for a sample of Azure Function acting as an API to update the content on SWA frontend. It does not show returned data in URL parameter but in the Body of HTML doc.
If you have a working sample to support this question, that should also help us help you. You may share it via GitHub repository (after ensuring that the personal identifiable information are stripped off).
Please let me know if you have any questions.