The BETWEEN operator in SQL is used to filter records where a column's value lies within a specified range, inclusive of the range's boundaries.