@JanIwnl welcome to the forum.
At this point, you have not provided enough information for someone to help you. No one but you knows:
- what platform you are using
- what version of Node-RED or node.js you are using (you can get this from the startup log)
- are you running Docker and/or Home Assistane
what the data being sent to theui-tablenode looks like - how you have configured the
ui-tablenode. - what you have in the template node.
My suggestion is to add a debug node (set to display the complete msg object) to the output of the sql node. Then put that data into an inject node and connect the inject node to the ui-table node and then select and export the inject node, ui-table node and template node and paste them to a reply and answer items 1, 2 and 3 above and that will give people a chance of helping you
In order to make code readable and usable it is necessary to surround your code with three backticks (also known as a left quote or backquote ```)
```
code goes here
```
You can edit and correct your post by clicking the pencil
icon.
See this post for more details - How to share code or flow json
.