How can I do a search and replace in vim that will replace everything between "this as that" and "from", regardless of the number of columns being selected in between?

desired.sql

select
this as that,
*
from
table_name

select
this as that,
*
from
table_name

solution.txt

# do this inside vim:
:%s/this as that,\_.\{-}from/this as that, *\rfrom/g

source.sql

select
this as that,
column1,
column2,
column3,
column4,
from
table_name

select
this as that,
column1
from
table_name