sqlite3: Add configure option to set or auto-detect rpath to sqlite3 libs

GitHub fields:

assignee = None
closed_at = None
created_at = <Date 2021-10-05.09:47:10.027>
labels = ['type-feature', 'expert-installation', 'build', '3.11']
title = 'sqlite3: Add configure option to set or auto-detect rpath to sqlite3 libs'
updated_at = <Date 2021-10-05.21:17:34.559>
user = 'https://bugs.python.org/chaz6'

bugs.python.org fields:

activity = <Date 2021-10-05.21:17:34.559>
actor = 'erlendaasland'
assignee = 'docs@python'
closed = False
closed_date = None
closer = None
components = ['Build', 'Installation']
creation = <Date 2021-10-05.09:47:10.027>
creator = 'chaz6'
dependencies = []
files = []
hgrepos = []
issue_num = 45374
keywords = []
message_count = 1.0
messages = ['403214']
nosy_count = 3.0
nosy_names = ['chaz6', 'docs@python', 'erlendaasland']
pr_nums = []
priority = 'normal'
resolution = None
stage = None
status = 'open'
superseder = None
type = 'enhancement'
url = 'https://bugs.python.org/issue45374'
versions = ['Python 3.11']