#include <Core/Core.h>
#include <Sql/Sql.h>

using namespace Upp;

struct CustomerTable
{
	const SqlId ID;
	const SqlId NAME;
	const SqlId AGE;
	
	operator SqlId()
	{
		return SqlId("CUSTOMER");
	}
	
	CustomerTable() :
	ID("CUSTOMER.ID"),
	NAME("CUSTOMER.NAME"),
	AGE("CUSTOMER.AGE")
	{}
};

CustomerTable CUSTOMER;
#define CUS CUSTOMER //alias

CONSOLE_APP_MAIN
{
	SqlSelect s = 
		::Select(CUSTOMER.NAME, CUSTOMER.AGE)
		.From(CUSTOMER)
		.Where(CUS.ID == 10);
		
	SqlStatement stmt = s;
	Cout() << stmt.GetText() << '\n';
}