How can I use parameters in plain sql

[John Adams <john_adams_mail@xxxxxxxxx>]

How can I use parameters in plain sql like sql server.

FICTIONAL example that works for sql server:
declare @i int;
set @i = 1;
select * from mytable where id=@i;