Better fallback SQL for backwards compatibility

[ReagentX]

From @rllbe in #151:

chat_recoverable_message_join table did not exist until iOS 16(at least not for iOS 15.4), but iMessage reply feature is supported since iOS 14.

imessage-exporter/imessage-database/src/tables/table.rs

Line 79 in c73bc4d

pub const RECENTLY_DELETED: &str = "chat_recoverable_message_join";

imessage-exporter/imessage-database/src/tables/messages.rs

Lines 151 to 164 in c73bc4d

	.unwrap_or(db.prepare(&format!(
	"SELECT
	*,
	c.chat_id,
	(SELECT COUNT(*) FROM {MESSAGE_ATTACHMENT_JOIN} a WHERE m.ROWID = a.message_id) as num_attachments,
	(SELECT NULL) as deleted_from,
	(SELECT 0) as num_replies
	FROM
	message as m
	LEFT JOIN {CHAT_MESSAGE_JOIN} as c ON m.ROWID = c.message_id
	ORDER BY
	m.date;
	"
	)).map_err(TableError::Messages)?)

This fallback SQL ignores the "message" table altogether, causing html outputs of iOS 14/15 backup not to show any reply signs at all.

Suggestion: adding another fallback SQL statement to the function below(and also the "stream_rows" function under it) would be good:

        .unwrap_or(db.prepare(&format!(
            "SELECT
                 *,
                 c.chat_id,
                 (SELECT COUNT(*) FROM {MESSAGE_ATTACHMENT_JOIN} a WHERE m.ROWID = a.message_id) as num_attachments,
                 (SELECT NULL) as deleted_from,
                 (SELECT COUNT(*) FROM {MESSAGE} m2 WHERE m2.thread_originator_guid = m.guid) as num_replies
             FROM
                 message as m
                 LEFT JOIN {CHAT_MESSAGE_JOIN} as c ON m.ROWID = c.message_id
             ORDER BY
                 m.date;
            "
        ))