Q: Override generated insert statement in JdbcIO with Apache Beam I wanted to write records in Postgres with a column type set as json. In Python version of JdbcIO, WriteToJdbc has a "statement" parameter which is suppose to override the generated insert statement. It seems that it is not working at all
| 'Write to jdbc' >> WriteToJdbc(
                table_name="teacher",
                driver_class_name='org.postgresql.Driver',
                jdbc_url='jdbc:{}://{}:{}/{}'.format("postgresql", "your ip address", "5432", "postgres"),
                username="postgres",
                password="password"
                statement = 'insert into researcher(id, first_name, last_name, total, payload) values (?, ?, ?, ?, cast(? as json))'
            )

Am I missing something here ?

A: The Python version of JdbcIO is still experimental and not fully supported.  There's an open Beam JIRA ticket for this feature: https://issues.apache.org/jira/browse/BEAM-10750
