Possible to dynamically create SQL in a stored procedure?

As the subject indicates, we are looking for a way to dynamically create an SQL statement within a stored procedure. The concept here is that part of the SQL is not known at the time the stored procedure is created, so it must be passed in as a run-time argument. The ESQL "prepare" construct does not appear to be valid within SPL, so I don't see a way to do this. Any ideas? Are we overlooking something? --