Anyone happened to know how to write in SQLA to
select v_1, v_2, v_3, ...., v_100 from...
in a shortcut way?
select v_1 - v_100 from ...
no, it's not possible to specify something like select v_1--v_100
you can generate the columnlist with SQL and copy paste the needed columns into your statement
select case when row_number() over (order by columnid) > 1 then ',' else '' end !! trim(columnname)
where databasename = 'dbc'
and tablename = 'columns'
order by columnid