Bookmark this to keep an eye on my life updates!
Dynamic SQL File manager IDEA plugin π§Έ Life π₯€ Food ποΈββοΈ GYM
This is dynamic sql paring as you think, if id is 11 ,you should be know the result!
select * from test.user where
-- #if :id >= 100
id = 99
-- #else
id = :id
-- #fi
You can get more information from rabbit-sql to set up your project, following a simple project, e.g

π‘ Oh donβt forget the IDEA-IU rabbit-sql-plugin, it will provides more help for you working with your project, test dynamic sql, e.g

Every thing will be better :)