Expression Tree Traversal Via Visitor Pattern in Practice

How to deal with expression trees, presented at C# as generic Expression type, to achieve some practical goals, for example - translating them to specific language like T-SQL.