What are their arguments for embedding the SQL in the application? Even if there were some marginal technical advantage, there is still issue that ownership of the SQL would then be moved from the domain of the DBA to the application developers. Is the app developer the smartest guy in the room when it comes to SQL, or are you?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho