detab.js

function detab(str) {
  return str.replaceAll(/^\s*|\s*$|(?<=(?:\n(\s*).*?)+)\1/g, "");
}

// Test

    let query = `
      SELECT 
        'table'.*
      FROM
        'database'.'table'
      WHERE
        'table'.'id' = NULL
     `;

    console.log(JSON.stringify(detab(query))); 
      // => "SELECT\n  table.*\nFROM\n  database.table\nWHERE\n  table.id = NULL"