[GENERAL] How can I use parameters in plain sql

[John Adams]

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 i...@i;