dynamic sql generation design

Good Afternoon,

We are bulding a web application and as part of it building a search functionality, have a design question on "Search Functionality"

The field names on the UI vs DB are different .i.e. a field on the UI called as "Number" the same is called Text10 in the DB. following are the two issues

1. How to generate a SQL as user gives the UI field names, we have a table in the DB where we r maintaining configuration(UI name to DB Name)?
2. User selects the columns which he wants to search, say for example there fields are selected "Number, Description, Price" and once the sql is generated, how to know what data corresponds to what column? Do we have to maintain an index capturing position or a bean? what is the better way to gather the data based on the resultset?

Thanks