javascript to generate sql strings with appropriately named aliased for each selected property.

sql.js

function selectFrom(table, props) {
	return 'SELECT ' + joinProperties(props) + ' FROM ' + table + '\n'
	function joinProperties(props) {
		return ' '+map(props, function(rawName, prettyName) {
			return rawName+' as '+prettyName
		}).join(', ')+' '
	}
}

selectFrom('person p', {
	fullName: 'p.full_name',
	bestFriendFullName: 'bff.full_name'
}) + ' INNER JOIN best_friend_forever bff'