postgresql "DO $$ BEGIN", not generate parameter.

[piyongcai-liucai]

What do you want to change?

query

DO $$ BEGIN
  DELETE
    FROM stage_seat
  WHERE stage_id = $1;     -- <--- HERE has parameter

  -- other sql 
END $$;

query

const resetStagePlace = `-- name: ResetStagePlace :exec
DO $$ BEGIN
  DELETE
    FROM stage_seat
  WHERE stage_id = $1;
END $$
`
//	DO $$ BEGIN
//	  DELETE
//	    FROM stage_seat
//	  WHERE stage_id = $1; -- <--- HERE has parameter
//  
//       -- other sql 
//	END $$
func (q *Queries) ResetStagePlace(ctx context.Context) error {   // <-- HERE, not generate parameter
	_, err := q.db.Exec(ctx, resetStagePlace)
	return err
}

feature request:
generate parameter for "DO $$ BEGIN ... END $$".

What database engines need to be changed?

PostgreSQL

What programming language backends need to be changed?

Go

[DanielRasho]

Same problem here

[esc20936]

Having the same issue here