Document SQLite event store implementation and integrate into documentation

[qodo-free-for-open-source-projects]

Description

• SQLite event store implementation was added in a previous PR (Add SQLite event store implementation #502) but lacked comprehensive documentation
• Users need clear guidance on how to configure, use, and integrate SQLite for event sourcing
• SQLite should be referenced consistently across all relevant documentation pages alongside other supported databases

Deliverables

• New documentation page: Create comprehensive SQLite event store documentation covering data model, event persistence, subscriptions, and projections
• Update references: Add SQLite to event store implementations list, supported projectors list, and packages table
• Checkpoint store docs: Document SQLite checkpoint store configuration and automatic table creation
• Consistent integration: Reference SQLite alongside PostgreSQL and SQL Server in introduction and capabilities sections

[linear]

EVE-219