design pattern for sql builder

Question

I want to write sql builder ( in: conditions(where, limits, table, etc), out: pure sql. ). Which design pattern nearest for this task?

Answer 1

Some kind of expression tree along with a visitor or maybe some kind of interpreter.

http://en.wikipedia.org/wiki/Visitor_pattern
http://en.wikipedia.org/wiki/Interpreter_pattern