How Alter postgres table definitions with ansible?

[simon_read]

We are using ansible to deploy postgres/schema/tables.
We require to patch the tables and therefore require to alter the tables (e.g. add or change type of columns).
There seems to be two modules related to this. postgresql_table (can create tables but not alter) and
postgres_query (seems to be for DML statements).

Can you advise? I am new too ansible and wonder why altering tables is not currently included with a module?

[Kai_Stian_Olstad]

The person(s) that created the module didn't have the need for the functionality and did not implement it.

Anyone can add the functionality if that want to, or hire someone to do it for them.