issue_comments: 1027656000

This data as json

html_url	issue_url	id	node_id	user	created_at	updated_at	author_association	body	reactions	issue	performed_via_github_app
https://github.com/simonw/datasette/issues/1618#issuecomment-1027656000	https://api.github.com/repos/simonw/datasette/issues/1618	1027656000	IC_kwDOBm6k_c49QMlA	9599	2022-02-02T07:27:14Z	2022-02-02T07:27:14Z	OWNER	I also just realized that `pragma pragma_list` can be used to generate a list of all known pragmas for the connection: sqlite-utils fixtures.db 'pragma pragma_list' --fmt github \| name \| \|---------------------------\| \| analysis_limit \| \| application_id \| \| auto_vacuum \| \| automatic_index \| \| busy_timeout \| \| cache_size \| \| cache_spill \| \| case_sensitive_like \| \| cell_size_check \| \| checkpoint_fullfsync \| \| collation_list \| \| compile_options \| \| count_changes \| \| data_version \| \| database_list \| \| default_cache_size \| \| defer_foreign_keys \| \| empty_result_callbacks \| \| encoding \| \| foreign_key_check \| \| foreign_key_list \| \| foreign_keys \| \| freelist_count \| \| full_column_names \| \| fullfsync \| \| function_list \| \| hard_heap_limit \| \| ignore_check_constraints \| \| incremental_vacuum \| \| index_info \| \| index_list \| \| index_xinfo \| \| integrity_check \| \| journal_mode \| \| journal_size_limit \| \| legacy_alter_table \| \| lock_proxy_file \| \| locking_mode \| \| max_page_count \| \| mmap_size \| \| module_list \| \| optimize \| \| page_count \| \| page_size \| \| pragma_list \| \| query_only \| \| quick_check \| \| read_uncommitted \| \| recursive_triggers \| \| reverse_unordered_selects \| \| schema_version \| \| secure_delete \| \| short_column_names \| \| shrink_memory \| \| soft_heap_limit \| \| synchronous \| \| table_info \| \| table_list \| \| table_xinfo \| \| temp_store \| \| temp_store_directory \| \| threads \| \| trusted_schema \| \| user_version \| \| wal_autocheckpoint \| \| wal_checkpoint \| \| writable_schema \| So I could use that list to create a much more specific regular expression, which would then allow the word "pragma" to be used more freely while still protecting against any known pragma function being called.	{"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	1121121305