Support queries having no "from" clause (MSSQL only?)

[davidAtInleague]

In MSSQL, the following is valid

select 42

I don't doubt that there are occasionally justifiable usages of the above pattern. But it is certifiably useful alongside {cross,outer}Apply, where the current row is just being laterally extended:

select users.ID, computedUserAge.xage
from users
cross apply (
  select 42 + users.age as xage
) computedUserAge
where computedUserAge.xage > 999

Maybe this can be as simple as updating SqlServerGrammer.cfc to override compileFrom:

private string function compileFrom( required QueryBuilder query, required any from ) {
    var clause = super.compileFrom(
        query = query,
        from = from
    )

    if (trim(clause) == "from") {
        return ""
    }
    else {
        return clause;
    }
}