For <2> and <3> well, yes. To do _anything_ in
Solr you need to index the data to Solr. It doesn't
magically reach out into the DB and do stuff.
<3> you can either use DIH or a SolrJ program
and yes, you do have to do some kind of mapping of
database columns into Solr documents
I want to caut
The docs describe the current capabilities. So if it's not in the docs,
it's not supported yet. For example the docs don't mention joins or
intersections and they are not supported. Another example is that select
count(*) is supported, and select distinct is supported, but select
count(distinct) is