If is a finitely complete category (a category with all finite limits), then it is interesting to consider a left exact functor on (a functor that preserves all finite limits). Even if lacks some finite limits, then this concept still makes sense, but it may not be the correct one. Instead we use the stronger concept of a flat functor, which may be thought of as a functor that preserves all finite limits —even the ones that don't exist yet!
There are two different definitions that both go by the name flat functor in the literature. For emphasis, we speak here of representably and internally flat functors, following (Shulman).
A functor is
representably flat if for each object , the opposite comma category is a filtered category
internally flat if …
For instance Johnstone, C2.3.7 and B3.2.3, where “internally flat functors” are called “torsors”.
Some authors call this precisely a left exact functor, see the definition there.
If is flat, then it preserves any finite limits that exist in .
A partial converse holds: if has enough finite limits and preserves these, then is flat.
If is a flat functor and
is its action on presheaves by precomposition, then the corresponding left adjoint
preserves finite limits.
The left adjoint is the left Kan extension along
Since presheaf toposes have all colimits, this is computed on any object (as discussed at Kan extension) by the colimit
where is the corresponding comma category and is the canonical projection.
Now, by definition being flat is equivalent to being a filtered category. So this is a filtered colimit. By the discussion there, it is precisely the filtered colimits that commute with finite limits.
If is a topos and is flat, then the functor (the Yoneda extension of , i.e. the left Kan extension of along the Yoneda embedding) preserves all finite limits (and now all finite limits exist).
For Set this is prop. 6.1.3 in (Borceux).
A similar statement holds when is a site and we extend a cocontinuous functor to . But a cocontinuous functor from preserving finite limits is (almost) the same thing as (the inverse image part of) a geometric morphism. So cocontinuous flat functors out of a site characterise (almost) geometric morphisms into . This can be very useful when a Grothendieck topos has a presentation by a particularly simple site.
For a category the full subcategory
of the category of presheaves on (which is the free cocompletion of ) on the flat functors is the free cocompletion under filtered colimits.
has finite limits precisely if for every finite diagram in , the category of cones on is filtered.
This is due to (KarazerisVelebil).
Representbaly flat functors are the topic of chapter 6 in
Internally flat functors (“torsors”) are discussed around B3.2 and representably flat functors around … in C2.3.7 of
The difference between internally and representably flat functors is discussed in
Limits in the category of flat functors are discussed in