Why My Queries Hate Application Service Layers

qProject >>
SELECT
	p.id,
	p.name
FROM
	project p
WHERE
	p.id = #project_id#
 
qAsset >>
SELECT
	a.id,
	a.name,
	a.filename,
	a.project_id
FROM
	asset a
WHERE
	a.id = #asset_id#
 
Validation >>
if
	(NOT qProject.RecordCount) OR
	(NOT qAsset.RecordCount) OR
	(qProject.id NEQ qAsset.project_id)
then
	// Throw error that data was not valid.

For Cut-and-Paste