{{ assuming you have this.datasource in your Application.cfc }}
variables.result = new select('*').from('token').execute();
writedump(var=variables.result,abort=1);

variables.datasource = "whatever";
variables.result = new select('*').from('token').withDatasource(variables.datasource).execute();
writedump(var=variables.result,abort=1);

variables.params = { 'id' = { value=5, type="int" }};
variables.result = new select('id').from('tablename').where('id = :id',variables.param).execute();
writedump(var=variables.result,abort=1);

variables.filter = "username";
variables.value = "webRat";
variables.columns = ['array','of','columns'];
variables.dbtable = "tablename";

var _query = new select(variables.columns).from(variables.dbtable);
var params = {};

switch(variables.filter){
	case "accountGUID":
		params = { 'create_guid' = { value = variables.value, type = "char" } };
		_query.where('create_guid = :create_guid AND active = 1 AND deleted = 0',params);
	break;
	case 'usernameOrEmail':
		params = { 'username' = { value = variables.value, type = "varchar" } };
		_query.where('(username = :username OR email = :username) AND active = 1 AND deleted = 0',params);
	break;
	case "username":
		params = { 'username' = { value = variables.value, type = "varchar" } };
		_query.where('username = :username AND active = 1 AND deleted = 0',params);
	break;
	default:
		params = { 'account_id' = { value = variables.id, type = "int" } };
		_query.where('account_id = :account_id and deleted = 0',params);
	break;
}
writedump(var= _query.execute(), abort=1);

params = {
	'account_guid' = { value = '8D02BF30-8779-4DA1-8614-A6BD58C41D38', type = "char" }
};

query = new select('t.*')
	.from('account AS a')
	.innerJoin('token AS t ON t.account_guid = a.create_guid AND t.account_guid = :account_guid',params)
	.limit(20,2)
	.withDatasource('metapose');

writedump(var=query.execute(),abort=1);

query = new select('t.*')
	.from('account AS a')
	.innerJoin('token AS t ON t.account_guid = a.create_guid AND t.account_guid = :account_guid',params)
	.limit(10)
	.offset(2)
	.withDatasource('metapose');

writedump(var=query.execute(),abort=1);

writedump(var=query.debug(),abort=1);