I pulled int32_publisher_custom_transport from the examples and replaced micro_ros_task() with the micro_ros_task() given by the multithread_publisher example. So, the code be like: #include ...

This way, one can do more complex queries, join tables, etc. The only issue, that we need to be able to dynamically modify this query. Maybe placeholders could be used, to mark places in SQL query, ...