Unanswered: Using original column names/aliases in web-forms
Inviting opinions on what is a better approach in web-forms: using the original column names or fake/alias names (with alias-column-mapping to keep the original column names from prying eyes). However, alias names would add a level of complexity and might impact performance. Eg:
<input type="text" name="user_id">
Real Column Name:
<input type="text" name="UserID">
Currently using a PDO class that quotes SQL and uses prepare to execute SQL and so, SQL-Injection may not be an issue at all. But I'm still confused if I should eliminate the aliases and stick with original column names to simplify and improve performance. Thoughts?