Build, test, and debug regular expressions
This regex is designed to extract table names from SQL queries by looking for the `FROM` or `JOIN` keywords, followed by spaces or an opening parenthesis. It then captures a dot-separated identifier (such as `schema.table` or `db.schema.table`) due to its specific structure. This makes it useful for parsing database-qualified table names from SQL statements.