id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
33288	SQLite schema introspection should use PRAGMA instead of parsing to retrieve foreign keys	Simon Charette	nobody	The SQLite backend's `DatabaseIntrospection.get_relations` uses a complex combination of regexes to extract foreign key constraints from DDL while [https://sqlite.org/pragma.html#pragma_foreign_key_list PRAGMA foreign_key_list] works just fine as [https://github.com/django/django/blob/0b95a96ee10d3e12aef01d449467bcf4641286b4/django/db/backends/sqlite3/introspection.py#L185 _get_foreign_key_constraints].	Cleanup/optimization	closed	Database layer (models, ORM)	dev	Normal	fixed			Ready for checkin	1	0	0	0	0	0