Doh, should have refreshed that bug before looking at it :)
Anyway, here's the same thing as Colin but with some notes attached to it.

General feeling is that it'll be quite hard to remove it from the archive. Demoting should be a lot easier, though php is probably not that much fun.

Binary packages: sqlite, sqlite-doc, libsqlite0, libsqlite0-dev, libsqlite0-tcl

stgraber@castiana:~$ apt-cache rdepends sqlite
sqlite
Reverse Depends:
  sympa                         # OK: Recommends both sqlite and sqlite3
  serendipity                   # NOT OK: Depends on mysql-client | postgresql-client | sqlite. Should be changed to sqlite3 once php5-sqlite only supports sqlite3 (currently uses both sqlite and sqlite3) (0 rdepends)
  roundcube-sqlite              # NOT OK: Depends on sqlite. Should be changed to sqlite3 once php5-sqlite only support sqlite3 (currently uses both sqlite and sqlite3) (2 rdepends)
  qsf                           # OK: sqlite is only a suggestion
  phpbb3                        # NOT OK: Depends on mysql-client | postgresql-client | sqlite. Should be changed to sqlite3 once php5-sqlite only supports sqlite3 (currently uses both sqlite and sqlite3) (2 rdepends)
  pdns-backend-sqlite           # NOT OK: Depends on sqlite. Should probably be dropped too as pdns-backend-sqlite3 already exists. (0 rdepends)
 |movabletype-opensource        # NOT OK: Depends on sqlite | mysql-client | postgresql-client, should be changed to sqlite3 (uses libdbd-sqlite3-perl) (0 rdepends)
  lire                          # OK: Suggests both sqlite and sqlite3
  imms-common                   # OK: Recommends both sqlite and sqlite3
  csync2                        # OK: Suggests sqlite
  beancounter                   # OK: Depends on either sqlite3 and sqlite
  bacula-director-sqlite        # NOT OK: Depends on either sqlite3 and sqlite (0 rdepends)
 |ansel1                        # OK: Recommends and sqlite3 is an alternative
  sqlite-doc                    # OK: Build from sqlite


stgraber@castiana:~$ apt-cache rdepends libsqlite0
libsqlite0
Reverse Depends:
  gentle                        # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (1 rdepends)
  teleport                      # NOT OK: Depends on libsqlite0 (0 rdepends)
  sqlrelay-sqlite               # NOT OK: Depends on libsqlite0 (0 rdepends)
  qsf                           # NOT OK: Depends on libsqlite0 (0 rdepends)
  python-sqlite-dbg             # NOT OK: Depends on libsqlite0 (1 rdepends)
  python-sqlite                 # NOT OK: Depends on libsqlite0 (14 rdepends)
  prismstumbler                 # NOT OK: Depends on libsqlite0 (0 rdepends)
  pdns-backend-sqlite           # NOT OK: Depends on libsqlite0 (0 rdepends)
  mnogosearch-sqlite            # NOT OK: Depends on libsqlite0 (0 rdepends)
  libtododb0                    # NOT OK: Depends on libsqlite0 (6 rdepends)
  libsqliteodbc                 # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (2 rdepends)
  libsqlite-tcl                 # OK: Build from sqlite (see below for rdepends)
  libqof2-backend-sqlite        # NOT OK: Depends on libsqlite0 (1 rdepends)
  libgpevtype1                  # NOT OK: Depends on libsqlite0 (6 rdepends)
  libgpeschedule0               # NOT OK: Depends on libsqlite0 (5 rdepends)
  libgpepimc0                   # NOT OK: Depends on libsqlite0 (9 rdepends)
  libeventdb2                   # NOT OK: Depends on libsqlite0 (6 rdepends)
  libdbd-sqlite                 # NOT OK: Depends on libsqlite0 (2 rdepends)
  libcontactsdb0                # NOT OK: Depends on libsqlite0 (5 rdepends)
  kannel-extras                 # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (0 rdepends)
  kannel                        # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (2 rdepends)
  gpesyncd                      # NOT OK: Depends on libsqlite0 (0 rdepends)
  gpe-todo                      # NOT OK: Depends on libsqlite0 (3 rdepends)
  gpe-timesheet                 # NOT OK: Depends on libsqlite0 (1 rdepends)
  gpe-contacts                  # NOT OK: Depends on libsqlite0 (3 rdepends)
  gpe-confd                     # NOT OK: Depends on libsqlite0 (1 rdepends)
  gpe-calendar                  # NOT OK: Depends on libsqlite0 (3 rdepends)
  gpe-bluetooth                 # NOT OK: Depends on libsqlite0 (0 rdepends)
  gpe-announce                  # NOT OK: Depends on libsqlite0 (4 rdepends)
  gambas2-gb-db-sqlite2         # NOT OK: Depends on libsqlite0 (1 rdepends), should be dropped as gambas2-gb-db-sqlite3 exists
  csync2                        # NOT OK: Depends on libsqlite0 (0 rdepends)
  asterisk                      # NOT OK: Depends on libsqlite0 (33 rdepends)
  sqlite                        # OK: Build from sqlite (see above for rdepends)
  php5-sqlite                   NOT OK: Depends on both libsqlite0 and libsqlite3-0 (12 rdepends)
  libsqlite0-dev                # OK: Build from sqlite
  libsasl2-modules-sql          # NOT OK: Depends on libsqlite0 (4 rdepends)
  libqt4-sql-sqlite2            # NOT OK: Depends on libsqlite0 (2 rdepends), should be dropped as libqt4-sql-sqlite exists
  libmono-sqlite2.0-cil         # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (13 rdepends)
  libmono-sqlite1.0-cil         # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (6 rdepends)

stgraber@castiana:~$ apt-cache rdepends libsqlite0-dev
libsqlite0-dev
Reverse Depends:
  kannel-dev                    # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (6 rdepends)
  cl-sql-sqlite                 # NOT OK: Depends on both libsqlite0 (1 rdepends)
  libqt4-dev                    # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (65 rdepends)

stgraber@castiana:~$ apt-cache rdepends libsqlite0-tcl
<libsqlite0-tcl>