Although I really enjoyed compilers in college I never thought I would build one for practical reasons. I ended up using the knowledge for two very interesting

Although I really enjoyed compilers in college I never thought I would build one for practical reasons. I ended up using the knowledge for two very interesting projects. One was a template engine in Java for turning variables into clauses in SQL queries. The other was an interpreter for PL/SQL that helps to extract procedures and functions in order to do partial updates of packages in production (the user chooses which procedures to send to production and doesn't have to update the whole package).