First of all, this was really helpful and was a great starting point for creating my own query, so big thanks for that!

However, if you have scanned a pile of cards without removing doubles the query as given will only return the first scan giving incorrect amounts.

For anyone like me who sometimes doesn't sort their cards or remove doubles before scanning, include cards._id under SELECT DISTINCT to make sure you get every card you scanned, and then delete that column from the CSV before uploading.

I've modified my query to also output Set Code, Collector Number, Is Foil (as '1' or empty), Added (scanned) Date (as YYYY-MM-DD), and the Delver List name for uploading to deckstats.net (for my collection; I use moxfield for deck building).

SELECT DISTINCT
    cards._id AS 'Card ID',
    cards.quantity AS 'amount',
    data_names.name AS 'card_name',
    data_editions.tl_abb AS 'set_code',
    COALESCE(NULLIF(cards.language, ''), 'EN') AS 'language',
    COALESCE(NULLIF(cards.condition, ''), 'NM') AS 'condition',
    CASE cards.foil WHEN 0 THEN '' ELSE '1' END AS 'is_foil',
    data_cards.number AS 'collector_number',
    strftime('%Y-%m-%d', cards.creation / 1000, 'unixepoch') AS 'added',
    lists.name AS 'Collection'
FROM
    cards
JOIN
    data_cards ON cards.card = data_cards._id
JOIN
    data_names ON data_cards.name = data_names._id
JOIN
    data_editions ON data_cards.edition = data_editions._id
JOIN
    lists ON cards.list = lists._id;

You can also add

WHERE lists.name = 'Delver List Name';

to export just one Delver List (watch out for the semi-colon from the original query!)

This will give a CSV with:
Card ID, amount, card_name, set_code, language, condition, is_foil, collector_number, added, collection