sandbox.py

import psycopg2
from psycopg2 import sql

query = sql.SQL("select {0} from {1} where {2} LIKE {3} {4}").format(sql.SQL(', ').join([sql.Identifier('foo'), sql.Identifier('bar')]), sql.Identifier('table'), sql.Identifier('coulumn'), sql.Placeholder(),
                                                                     sql.SQL('AND 1 = 1'))

with psycopg2.connect(database='temperatures_berteld_morstein', user='postgres', password='postgres', host='localhost', port=5432) as connection:
    with connection.cursor() as cursor:
        print(query.as_string(cursor))