m_array.AddKey(PR_ID); //primary key
m_array.AddColumn(PR_CREATIONDATE, t_("Creation Date"), 10)
    .SetConvert(Single<ConvertYourIntBasedDate>());
...
m_array.AddColumn(COM_NAME, t_("Company Name"), 10);
...

SqlSet GetSqlColumns(const ArrayCtrl &a_array)
{
	SqlSet cols;
	for(int i = 0; i < a_array.GetIndexCount(); i++)
		if(!a_array.GetId(i).IsNull())
			cols.Cat(SqlId(a_array.GetId(i)));
	return cols;
}

SqlSet cols = GetSqlColumns(m_array);
Sql sql;
sql * ::Select(Distinct(cols))
	.From(PROJECT)
	.LeftJoin(COMPANY)
	.On(COM_ID == PR_COMPANYID)
	.Where(1)
	.OrderBy(PR_ID)
;

for(;;) {
	Vector<Value> row;
	if(!sql.Fetch(row)) break;
	m_array.Add(row);
}