const regex = /(select)(.*?)(from)[\\r\\n]*/gim;
// Alternative syntax using RegExp constructor
// const regex = new RegExp('(select)(.*?)(from)[\\\\r\\\\n]*', 'gim')
const str = `SELECT\\r\\n money\\r\\nFROM\\r\\n accounts
"SELECT\\r\\n device_id\\r\\nFROM\\r\\n temp.test_sets AS device_infos\\r\\nJOIN (\\r\\n SELECT\\r\\n google_ad_id\\r\\n FROM\\r\\n test*\\r\\n)`;
const subst = `\1 count(*) \2`;
// The substituted value will be contained in the result variable
const result = str.replace(regex, subst);
console.log('Substitution result: ', result);
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for JavaScript, please visit: https://developer.mozilla.org/en/docs/Web/JavaScript/Guide/Regular_Expressions