Direct Mode Postgres Query

[Nicolas Paris <ni...@gmail.com>]

Hello

After some testing, sqoop --direct mode the best way to get data from
postgres.

However, this mode is limited to a --table: it is not possible to pass
any --query.

Sadly, postgres COPY command allows to pass a query. This would be then
in theory feasible to export from any SQL query with --direct mode. 

My use case, is I do not want to export multiple tables from postgres,
but one SQL composition of the tables. The alternative would be to
create a view inside postgres to mimic a table. But I do not have the
sufficient privileges to do so.

Thanks for any feedbac