ZhAgent/apps/application/sql/list_application_chat_ee.sql

select application_chat.*,
       (CASE
            WHEN "chat_user".id is NULL THEN application_chat.asker
            ELSE jsonb_build_object('id', chat_user.id, 'username',
                                    chat_user.nick_name) END) ::json AS asker, application_chat.source::json AS source
from application_chat application_chat
         left join chat_user chat_user on chat_user.id::varchar = application_chat.chat_user_id ${default_queryset}