Can we execute a sql query dynamically without metadata injector ?

Yes, you can use the ‘Dynamic SQL row’ step where you can pass the sql query dynamically from the previous step or using a parameter.