Good day everyone. Wanted to understand rationale behind the decision to return empty dict when query returns no result. Looking through the code I see that this is intentional and explicit (community.postgresql/plugins/modules/postgresql_query.py at f3789b7c7c427f39a01dcc157810c4d835f24cee · ansible-collections/community.postgresql · GitHub). But documentation states that query_result is a list of dict objects, so imo this behavior contradicts with what is said in the doc.
Also it seems that one of the latest ansible core updates are now failing loops when empty dict is passed instead of list.
Maybe the doc can be updated to reflect this.