You can use the "regexp_match" function to perform regular expression matching within SQL queries. This function allows you to extract matched substrings from a text column based on a regular expression pattern. 

Example:

SELECT regexp_match(column_name, 'your_regex_pattern') AS matched_text 
FROM table_name;