Inserting multiple commands into prepared statement rails

Question

I am using rails 3 and I need to execute raw sql in one of my migration and I need to do it using prepared statement since it is the best way to escape problems which arise due to single, statement or so. Is there a way where in I can execute multiple sql statements in a single prepare statement. I am using PostgreSQL for my database

Here is my code what i tried

  CONN = ActiveRecord::Base.connection.raw_connection  
  sql = %Q[
            INSERT INTO table1 
              (
                name,
                email,
                phone,
                created_at,
                updated_at
               ) 
              VALUES 
              (
                $1, 
                $2, 
                $3,
                current_timestamp, 
                current_timestamp
              );
            UPDATE table2 
              SET column_1 = $1
              WHERE id = $4;
            UPDATE contacts SET 
              column_2 = $2
              WHERE id = $4
          ]

  CONN.prepare('insert_and_update', sql)
  CONN.exe_prepared('insert_and_update', [
      name,
      email,
      phone,
      customer.id
    ])

But I am getting error as

 cannot insert multiple commands into a prepared statement

Answer 1

Turn it into a single command:

with i as (
    insert into table1 (
        name,
        email,
        phone,
        created_at,
        updated_at
    ) values (
        $1, 
        $2, 
        $3,
        current_timestamp, 
        current_timestamp
), u as (
    update table2 
    set column_1 = $1
    where id = $4
)
update contacts 
set column_2 = $2
where id = $4
;