SQLite: "Cannot read property 'name' of undefined" when loading foreign keys of a table

[Obiwan1995]

Issue Description

When loading foreign keys of a table, I get this error Cannot read property 'name' of undefined. It's because foreign keys mapping can't be found. I looked a bit deeper and found that the regex for foreign keys didn't match the CREATE TABLE sql because the regex expects a space between FOREIGN KEY and the list of columns.
As stated in SQLite documentation (https://www.sqlite.org/foreignkeys.html), the space is not mandatory:

CREATE TABLE track(
  trackid     INTEGER, 
  trackname   TEXT, 
  trackartist INTEGER,
  FOREIGN KEY(trackartist) REFERENCES artist(artistid)
);

I've tested the regex in the code on regex101.com with the example provided by SQLite and it does not match.

Expected Behavior

The regex should handle both space and no-space syntaxes and it should successfully match the CREATE TABLE sql to get the foreign keys.

Actual Behavior

Cannot read property 'name' of undefined / AbstractSQLiteQueryRunner.ts, line 1510.

Steps to Reproduce

1. Create a table with the script above
2. Call loadTable on it

My Environment

Dependency	Version
Operating System	Windows 10
Node.js version	16.15.1
Typescript version	4.7.4
TypeORM version	0.3.7

Additional Context

Relevant Database Driver(s)

DB Type	Reproducible
aurora-mysql	no
aurora-postgres	no
better-sqlite3	no
cockroachdb	no
cordova	no
expo	no
mongodb	no
mysql	no
nativescript	no
oracle	no
postgres	no
react-native	no
sap	no
spanner	no
sqlite	yes
sqlite-abstract	yes
sqljs	yes
sqlserver	no

Are you willing to resolve this issue by submitting a Pull Request?

• ✅ Yes, I have the time, and I know how to start.
• ✖️ Yes, I have the time, but I don't know how to start. I would need guidance.
• ✖️ No, I don’t have the time, but I can support (using donations) development.
• ✖️ No, I don’t have the time and I’m okay to wait for the community / maintainers to resolve this issue.