The explode() function in Spark SQL takes an array (or map) column and returns a new row for each element in the given array, effectively expanding a single row with an array of 5 items into 5 distinct rows.