How to do insert with the SQL macro command?

I'm trying to create a Macro type universal function with something like this: 

SQL(insert into my_table values('test')) 

It seems the parenthesis within the SQL statement conflicts with the Macro syntax which is SQL(your-sql).  

How can I do this then?