Programming :: Line Buffering Using Here Document In Bash?

I keep time sheet entries at work in an sqlite database called 'timesheet'. I have a shell script called 'today' which queries for all timesheet entries which are less than 24 hours old; it looks like this:

Code:
#!/bin/bash
echo "select datetime(start_time, 'unixepoch', 'localtime'), datetime(end_time, 'unixepoch', 'localtime'), project, site, duration from timesheet where start_time > strftime('%s', 'now', '-1 day', 'localtime');" | sqlite3 ~/.timesheet/timesheet.db

In an effort to make it more readable, I've put the query inside a here document:

Code:
#!/bin/bash
cat | sqlite3 ~/.timesheet/timesheet.db << query
select

[Code]...