The longer answer is Yes it is technically possible. The question is whether it is worthwhile.
CA Gen uses the SOME and THAT feature to remove columns from the SELECT list of a READ/READ EACH as indicated in the example below based on the CA Gen SAMPLE model. Here the requirement is to read the id and name of all full time employees with no telephone number.
The CA Gen code
* +-> NOT_ALL_COLUMNS_IN_SELECT 02/14/2017 07:19
* ! ENTITY ACTIONS:
* ! Entity View sat employee
* ! number
* ! name
* ! home_phone
* ! work_phone
* ! full_time_status
* ! Entity View employee
* ! number
* ! name
* !
* ! PROCEDURE STATEMENTS
1* !
2* ! +=>READ EACH (No Distinct) employee
2* ! ! WHERE DESIRED employee number = SOME sat
2* ! ! employee number
2* ! ! AND THAT sat employee home_phone = SPACES
2* ! ! AND THAT sat employee work_phone = SPACES
2* ! ! AND THAT sat employee full_time_status =
2* ! ! "F"
2* ! +--
* +---
The resulting SQL
SELECT
EMPLOYEE01."NUMBER",
EMPLOYEE01."NAME0"
FROM
"EMPLOYEE" EMPLOYEE01,
"EMPLOYEE" EMPLOYEE02
WHERE
(
EMPLOYEE01."NUMBER" = EMPLOYEE02."NUMBER" AND
EMPLOYEE02."HOME_PHONE" = ' ' AND
EMPLOYEE02."WORK_PHONE" = ' ' AND
EMPLOYEE02."FULL_TIME_STATUS" = 'F'
)