A hastly put together filter plugin for postgres identifier (not yet functional)

pgidentifier.py

# A hastly put together filter plugin to try have Ansible's `postgresql_query` module
# deal with identifiers correctly.
# References:
# * Postgres identifiers
#   https://www.postgresql.org/docs/11/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
# * Psycopg2 handling of identifiers (cf. last example in the section)
#     http://initd.org/psycopg/docs/usage.html#passing-parameters-to-sql-queries
from psycopg2 import sql
from ansible.plugins.filter import core


def pgidentifier(value):
    core.mandatory(value)  # Useful ?
    return sql.Identifier(value)


class FilterModule(object):
    def filters(self):
        return {'pgidentifier': pgidentifier,
                }